From: | Vegard Bønes <vegard(dot)bones(at)met(dot)no> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SQL names for C constants |
Date: | 2007-02-27 07:58:19 |
Message-ID: | 45E3E49B.8020005@met.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
I am writing a serverside function in plpgsql, which returns a part of a
large object.
To solve this problem I can do something like this:
fd := lo_open( some_oid, 262144 );
PERFORM lo_lseek( fd, index, 0 );
RETURN loread( fd, read_size );
This works well enough, but I do feel slightly uneasy about using
numbers instead of symbolic names (262144 for INV_READ and 0 for
SEEK_SET). I do especially find SEEK_SET unsettling, since this constant
is defined outside of postgresql, and it may therefore be defined to
other values than 0 on other platforms.
Am I missing something here? Is there a way to specify these names
without writing the actual numbers, or should I just close my eyes and
hope that everything will work?
thanks
VG
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2007-02-27 08:28:46 | Re: stored procedure optimisation... |
Previous Message | Tom Lane | 2007-02-27 07:57:28 | Re: dropping a master table and all of its partitions? |