Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Sybase > Re: SELECT 42 A...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 7 of 15 Topic 2401 of 2544
Post > Topic >>

Re: SELECT 42 AS a, a AS b FROM system.iota

by dtmackenzie <david.mackenzie@[EMAIL PROTECTED] > Feb 13, 2008 at 05:35 AM

> I'm wondering if a is a column of system.iota ...
>
> David, does "select a as b from system.iota" work ?
>
> Luc.

Luc, system.iota in ADS is a table with a single row and a single
column, also named "iota".
As expected, "select a as b from system.iota" returns an error message
that column "a" does not exist.

My example is simplified as far as possible for demonstration purposes
but it's not just a theoretical problem - in the real SELECT I have a
longer expression instead of "42" which I would like to avoid
repeating within the expressions for several other columns.

David
 




 15 Posts in Topic:
SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-12 04:56:52 
Re: SELECT 42 AS a, a AS b FROM system.iota
"mpeppler@[EMAIL PRO  2008-02-13 02:10:54 
Re: SELECT 42 AS a, a AS b FROM system.iota
Luc Van der Veurst <db  2008-02-13 12:31:39 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-13 03:22:30 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-13 05:17:00 
Re: SELECT 42 AS a, a AS b FROM system.iota
Luc Van der Veurst <db  2008-02-13 13:38:16 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-13 05:35:49 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-13 06:51:31 
Re: SELECT 42 AS a, a AS b FROM system.iota
Luc Van der Veurst <db  2008-02-13 15:14:04 
Re: SELECT 42 AS a, a AS b FROM system.iota
--CELKO-- <jcelko212@[  2008-02-14 01:53:34 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-14 08:15:08 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-15 00:53:09 
Re: SELECT 42 AS a, a AS b FROM system.iota
--CELKO-- <jcelko212@[  2008-02-17 20:48:25 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-18 06:58:29 
Re: SELECT 42 AS a, a AS b FROM system.iota
dtmackenzie <david.mac  2008-02-18 06:58:40 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Oct 15 21:54:07 CDT 2008.