hello 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 sincerely siva
-------- Original Message -------- Subject: Re: [GENERAL] query help From: "Alexander Staubo" <[EMAIL PROTECTED]> Date: Thu, September 13, 2007 11:17 am To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > hello > > table is > +-------+-------+------+-------+ > | id | one | two | three | > +-------+-------+------+-------+ > | first | Jack | Jill | Mary | > | last | Ja | Ji | Ma | > +-------+-------+------+-------+ > > result is > +----+-------+-------+ > | id | one | two | > +----+-------+-------+ > | first | Jack | Jill | > | last | Ja | Ji | > +----+-------+-------+ > > query is?? Unless I am missing something crucial, this is SQL 101: select id, one, two from foo; Alexander. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
