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: query help From: "Alexander Staubo" <alex@xxxxxxxxxxxxxxx> Date: Thu, September 13, 2007 11:17 am To: "volunteer@xxxxxxxxxxxxxxx" <volunteer@xxxxxxxxxxxxxxx> Cc: pgsql-general@xxxxxxxxxxxxxx On 9/13/07, volunteer@xxxxxxxxxxxxxxx <volunteer@xxxxxxxxxxxxxxx> 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
