Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6AEq5a30371 for ; Tue, 10 Jul 2001 10:52:05 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 753EE2AB3A; Tue, 10 Jul 2001 11:52:14 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: Laurent Patureau Subject: Re: SELECT column name Date: Tue, 10 Jul 2001 05:52:12 -0300 X-Mailer: KMail [version 1.2] References: <5.1.0.14.0.20010710164328.00a258e0@172.16.48.1> In-Reply-To: <5.1.0.14.0.20010710164328.00a258e0@172.16.48.1> Cc: pgsql-php@postgresql.org MIME-Version: 1.0 Message-Id: <01071005521201.11667@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/5 X-Sequence-Number: 462 On Mar 10 Jul 2001 11:47, you wrote: > Hi, > > I 'd like to select column name on table for a client Where value for this > client for columns is yes : > > SELECT columns_name WHERE client='$client' AND column.values='oui' Could this be: SELECT columns_name WHERE client=CURRENT_USER AND column.values='oui' Saludos... :-) -- Cualquiera administra un NT. Ese es el problema, que cualquiera administre. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------