int4out - Mailing list pgsql-general

From Juriy Goloveshkin
Subject int4out
Date
Msg-id Pine.BSF.4.21.0007051716350.23322-100000@localhost
Whole thread Raw
List pgsql-general
Hi all,

What int4out function does?
this function is used in odbc driver to recive list of tables.
'select ... int4out(usesysid) = int4out(relowner) ...'
but this function in my system(FreeBSD-Current) return something very
strange.
I have replaced this to 'usesysid=relowner' and list of tables have been
shown.

============
li@juriy[tmp]$ psql -U pgsql test
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

test=# select version();
                                  version
---------------------------------------------------------------------------
 PostgreSQL 7.1devel on i386-unknown-freebsdelf5.0, compiled by GCC 2.95.2
(1 row)

test=# select int4out(1);
  int4out
-----------
 136327536
(1 row)

test=# select int4out(1);
  int4out
-----------
 136327656
(1 row)

test=# select int4out(1);
  int4out
-----------
 136327656
(1 row)

test=# select int4out(1);
  int4out
-----------
 136327656
(1 row)

test=# select int4out(10);
  int4out
-----------
 136327656
(1 row)

test=# \q
li@juriy[tmp]$ exit
===================

Bye
Juriy Goloveshkin


pgsql-general by date:

Previous
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: responses to licensing discussion
Next
From: "Joseph"
Date:
Subject: RE: ODBC and Connection staying open