On 8/4/2004 1:58 PM, David Rysdam wrote:
Doug McNaught wrote:
David Rysdam <[EMAIL PROTECTED]> writes:
Right now I'm having to write a program to create all the large
objects up front and record the OIDs in a file which I will then COPY
in with the rest of my data.
You might consider using
On Sat, 2004-08-07 at 14:40, David Garamond wrote:
> Is there anyone on this list who has preferred to use regexes from PL's
> (e.g. plperl, plruby) in CHECK constraints or other places instead of
> the flavor provided by Postgres? Do you find your approach satisfying?
> Do you also do things li
Is there anyone on this list who has preferred to use regexes from PL's
(e.g. plperl, plruby) in CHECK constraints or other places instead of
the flavor provided by Postgres? Do you find your approach satisfying?
Do you also do things like cache the pattern so you don't have to
compile the rege
In Postgres 7.4 and earlier you can do the following:
select '{{"1 2" x},{3}}'::text[];
text
-
{{"1 2 x"},{3}}
(1 row)
I regard this as a bug, and am contemplating commiting a fix this
weekend against 8.0devel. However it was brought up on HACKERS that
since this has always
Jiri Nemec wrote:
id price_from price_to rounding
1 0 1500 0.1
2 1500 5000 1
3 5000 15000 10
4 15000 0 100
Eg.:
price = 15.5758, rounded = 15.6
price = 1825.5540, rounded = 1826
price =
Kevin,
I've been casually following this thread (you might say "lurking"), and
I don't know *why* the problem is occurring, but you said that you
didn't see a foolproof way to break the problem into steps. I think
there is such a way, which will at least allow you to get the job done.
This exam
