From: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
---|---|
To: | Ivan <iv(at)psycho(dot)pl> |
Cc: | Richard Huxton <dev(at)archonet(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Few Simple Questions |
Date: | 2003-02-28 20:19:54 |
Message-ID: | Pine.GSU.4.44.0302281218350.13762-100000@eskimo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> tru, bat its not very good idea, because there can be duplicate keys,
Create the temporary table with a primary key.
> or what with broken transmision ???
How is that different than a normal session variable?
> better will be something like SET .. ???
How would it be any different?
You could wrap it with functions. create_session() set_variable('name',
'value') get_variable('name')
Jon
>
> > > > how can declare and define my own variables in each connect to db, and
> > > > read it / or change it in plpgsql function ?
> >
> > You can do this, I believe, by creating a temporary table holding
> > key/value pairs.
> >
> > Jon
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-02-28 20:22:58 | Re: phpBB2 slow on postgres vs mysql ? |
Previous Message | Ivan | 2003-02-28 20:15:09 | Re: Few Simple Questions |