can u refer to row?? howto select * from table where row(#2) like 'J%'??
i wanted to test column storing but not ok as no row refer name/id.
many thank yous
sincerely
siva
-------- Original Message --------
Subject: Re: [GENERAL] query help
From: volunteer@spatiallink.org
Date: Thu, September 13, 2007 11:46 am
To: Alexander Staubo <alex@purefiction.net>
Cc: pgsql-general@postgresql.org
many apologees. right link
http://archives.postgresql.org/pgsql-general/2007-09/msg00607.php
i flip row to column if ok. but howto query??
sincerely
siva
-------- Original Message --------
Subject: Re: [GENERAL] query help
From: "Alexander Staubo" <alex@purefiction.net>
Date: Thu, September 13, 2007 11:38 am
To: "volunteer@spatiallink.org" <volunteer@spatiallink.org>
Cc: pgsql-general@postgresql.org
On 9/13/07, volunteer@spatiallink.org <volunteer@spatiallink.org> wrote:
> i add more column not row for new user. i want all "last like 'J%'".
> http://www.nabble.com/an-other-provokative-question---tf4394285.html
Sorry, but the only difference between your table example and your
result example was the absence, in the results, of one of the columns.
If you want to constrain by some attribute, then you have to tell us
that. I recommend that you buy a book on SQL. Lastly, I don't see what
this has to do with the "provokative question" thread.