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: [EMAIL PROTECTED] Date: Thu, September 13, 2007 11:46 am To: Alexander Staubo <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> Date: Thu, September 13, 2007 11:38 am To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
