Re: In or Exists? - Mailing list pgsql-jdbc

From Fabrice.Sznajderman@devoteam.com
Subject Re: In or Exists?
Date
Msg-id OFC84DB0F0.F081C57C-ONC1257116.005A4A86-C1257116.005AA8F9@devoteam.com
Whole thread Raw
In response to Re: In or Exists?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: In or Exists?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: In or Exists?  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-jdbc

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@g2switchworks.com>
Envoyé par : pgsql-jdbc-owner@postgresql.org

15/02/2006 17:27

A
Fabrice.Sznajderman@devoteam.com
cc
Objet
Re: [JDBC] In or Exists?





On Wed, 2006-02-15 at 09:59, Fabrice.Sznajderman@devoteam.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

pgsql-jdbc by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: In or Exists?
Next
From: Scott Marlowe
Date:
Subject: Re: In or Exists?