Обсуждение: query help
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?? sincerely siva
On 9/13/07, volunteer@spatiallink.org <volunteer@spatiallink.org> 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.
On 9/13/07, volunteer@spatiallink.org <volunteer@spatiallink.org> wrote: > query is?? http://www.w3schools.com/sql/default.asp
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" <alex@purefiction.net> Date: Thu, September 13, 2007 11:17 am To: "volunteer@spatiallink.org" <volunteer@spatiallink.org> Cc: pgsql-general@postgresql.org On 9/13/07, volunteer@spatiallink.org <volunteer@spatiallink.org> 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/
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. Alexander.
volunteer@spatiallink.org wrote: > 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 You add a new _column_ for each user?!? That is hideously broken in so many ways. It makes the trivially easy query you are trying to write rather complicated, prevents you from being able to use indexes for either constraints or performance and requires you to change your table definition anytime you add data. And that's just for starters. Fix your table so it has three columns (id, first, last). Then your query is as easy as: select id,first,last from foo where last like 'J%'; Cheers, Steve
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. Alexander. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
volunteer@spatiallink.org wrote: > hello > i add more column not row for new user. i want all "last like 'J%'". I get the feeling that the result as you've laid it out is not what we all think it is. For example: >>table is >>+-------+-------+------+-------+ >>| id | one | two | three | >>+-------+-------+------+-------+ >>| first | Jack | Jill | Mary | >>| last | Ja | Ji | Ma | >>+-------+-------+------+-------+ I took that to meant that you have columns 'id', 'one', two', three', and that 'first' & 'last' are field values. However, it now seems that 'first' & 'last' are column names. If so, this makes no sense. I think what you wanted to give us was: +-------+-------+------+ | id | first | last | +-------+-------+------+ | one | Jack | Ja | | two | Jill | Ji | | three | Mary | Ma | result: +-------+-------+------+ | id | first | last | +-------+-------+------+ | one | Jack | Ja | | two | Jill | Ji | So, the query you want is, in fact: SELECT * FROM your_table WHERE last LIKE ('J%'); If that's not working for you, it's perhaps because you have rows for columns and columns for rows. > http://www.nabble.com/an-other-provokative-question---tf4394285.html > sincerely > siva > What the heck does this have to do with anything? Please don't top-post. brian
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.