Re: In or Exists?

I tried select version();

it gave me this:

PostgreSQL 7.2.3-RH on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)

I really newbie with postgres...

Can u help me?
thank in advance!!

Fabrice

Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Envoyé par : pgsql-jdbc-owner(at)postgresql(dot)org
15/02/2006 17:27

A
Fabrice(dot)Sznajderman(at)devoteam(dot)com
cc

Objet
Re: [JDBC] In or Exists?

On Wed, 2006-02-15 at 09:59, Fabrice(dot)Sznajderman(at)devoteam(dot)com wrote:
> thank you for your answer!
>
>
> how I can know the version of my postgres DataBase ?
> I know is 7.3.x but I don't know for the 'x' number ..

psql -V will tell you the client version. or psql template1 -c "select
version();" will tell you the version of the backend server.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

+---------------------------------------------------------------------+
About Devoteam:

Devoteam is an IT consulting group.
Combining consulting and technology solutions offers enables
Devoteam to provide its customers with independent advice and
effective solutions to align their information system's technical
infrastructure with their operational objectives.
The group achieved a turnover of 199 million euros in 2005
an operating margin of 7% and counts 2,100 employees through
12 European countries and the Middle East.
Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy,
IT CAC, IT CAC 50, SBF 250 index of Euronext Paris.
www.devoteam.com
+---------------------------------------------------------------------+