Hello,
First of all: I' m using postgresql v7.0.2 on debian 2.2. (and I have two
completely different questions)
i) What is the most effective representation of
type "set" in postgres?
As I remember there is no attribute type to
represent definitely sets. (Please, correct me
if I'm
Hello,
I realised what I wrote in my last message was really confused.
You are absolutely right, I try to describe the whole situation.
1) There is a table which stores the goods of the vendors:
=#CREATE TABLE device (device_id serial, vendor_id integer, ... and some other
columns);
2) there i
hello everyone,
is there any possibility to keep the value of an arbitrary type variable in a plpgsql
function between its invocations?
If not, can it be made with functions written in C instead? I've "static storage" in
my mind.
Can it be made thread-safe?
- Papp Gyozo -
Hello,
I came up against the same (or similar) difficulty some month ago.
Then Tom Lane suggested me to write a simple sql or plpgsql function which handles the
multiple delete action.
(BTW, maybe you don't want to use the on delete cascade referential integrity in some
cases.)
Sorry, but I ca
ot;Tom Lane" <[EMAIL PROTECTED]>
To: "Gyozo Papp" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 2001. május 4. 20:26
Subject: Re: [GENERAL] arbitrary number of values from a sequence
> "Gyozo Papp" <[EMAIL PROTECTED]> writes:
> > Do
Maybe this helps you:
starttime datetime default now(),
endtime datetime default (now() + interval('1 hour'))
- Original Message -
From: "Stuart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 2001. április 30. 21:18
Subject: [GENERAL] datetime arithmatic
> Folks,
>
> I am new to
