[SQL] Distinct Values

How do I build the SQL Query ? I tried to use: "SELECT DISTINCT Author FROM Books" But this does not allow me to fetch the URL value on the other colomn. Thanks Nicolas ---(end of broadcast)--- TIP 2: you can get off all lists at

[SQL] Protection of tables by group and not by users

Hello, Is it possible to protect a table of Postgresql by a group of persons instead of giving a list of persons ? Thanks for your answers Regards nicolas michaud

[SQL] Let join syntax

rite this query correctly ? Regards, Nicolas. ------- Nicolas JOUANIN - SA REGIE FRANCE Village Informatique BP 3002 17030 La Rochelle CEDEX Tel: 05 46 44 75 76 Fax: 05 46 45 34 17 email: [EMAIL PROTECTED] Web : www.r

[SQL] Let join syntax

fred Koizar [mailto:[EMAIL PROTECTED] > Envoye : lundi 16 juin 2003 16:40 > A : Nicolas JOUANIN > Cc : [EMAIL PROTECTED] > Objet : Re: [SQL] Let join syntax > > > On Mon, 16 Jun 2003 12:34:34 +0200, "Nicolas JOUANIN" > <[EMAIL PROTECTED]> wrote: > >fro

Re: [SQL] CREATE table1 FROM table2

Hi, Documentation says: CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] AS query example : create table table1 as select * from table2; > -Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] la part de Rado Petrik > Envoyé

[SQL] TR: Like and =

oes my field contain trailing spaces ? Regards and thanks again for your useful help. PS: create table pdi ( pmf_id char(4) not null , pro_id char(25) not null , lng_id char(3) not null , pdi_desc char(50) not null , pdi_instr text, pdi_match

Re: [SQL] TR: Like and =

Hi, Thanks for your help. In fact that means 2 solutions for this: 1) select * from pdi where rtrim(pdi) = '100058' or 2) Use VARCHAR instead of CHAR I don't which is the best , but both are working. Nicolas. > -Message d'origine- > De : Randall Luca

Re: [SQL] TR: Like and =

la part de Dani Oderbolz > Envoye : mercredi 25 juin 2003 14:19 > A : [EMAIL PROTECTED] > Objet : Re: [SQL] TR: Like and = > > > Nicolas JOUANIN wrote: > > >Hi, > > > > Thanks for your help. In fact that means 2 solutions for this: > > > >1) select

[SQL] Caracter é

Hello, I compiled Postgresql 8 on my server and installed it I am trying to insert a string using php and PEAR::DB The string contain: é and this cause $db-query to fail with an Unkown error as error message. If i insert the data using pgAdminIII the string is inserted into the table. I don

[SQL] unsuscribe

unsuscribe ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] unsuscribe

unsuscribe ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[SQL] Special grouping on sorted data.

:26.166675 C| 2 | 2008-09-20 06:19:46.459439 | 2008-09-20 06:20:04.634328 If I write a GROUP BY b,n there is going to be only two rows for b = 'A', if I use distinct on i get the same thing is there an easy way to do that ? Nicolas -- Sent via pgsql-sql mailing list (pgs

Re: [SQL] Special grouping on sorted data.

was more flexible, it's not happy when the order by set is different than the distinct on set. I would like to be able to write select distinct on (b,n) b,n,stamp from table where ... order by stamp; Nicolas -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Special grouping on sorted data.

I which distinct on ... I wish distinct on ... -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql