For more information, i know how this is done using the pg_catalog but
have yet to find out how its done with the information schema.

select * from pg_catalog.pg_database where datname='test'

will work for me but i can't find a solution with the IS.  I'd prefer
to use the IS if its as easily done as with pg_catalog

Jon

---------------------------(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

Reply via email to