From: pgsql-sql-ow...@postgresql.org
[mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Jan Verheyden
Subject: [SQL] simple? query
Hi,
I was trying to run following query but doesn't work:
if (uid='janvleuven10') then
insert into test (registered) values ('1');
else
insert into
On 2009-08-12, Jan Verheyden jan.verhey...@uz.kuleuven.ac.be wrote:
--_000_E30C7040DE22624185BAD4093190B54437BE5DB4A9EX2007MBX2uzk_
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
It's on Windows
I'd go with notify and a listener written in C using
Jasen Betts wrote:
On 2009-08-12, Jan Verheyden jan.verhey...@uz.kuleuven.ac.be wrote:
--_000_E30C7040DE22624185BAD4093190B54437BE5DB4A9EX2007MBX2uzk_
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
It's on Windows
I'd go with notify and a
Alvaro Herrera alvhe...@commandprompt.com wrote:
It's on Windows
I'd go with notify and a listener written in C using c-client to send
emails, but only because I've used those before.
I wouldn't write it in C but rather Perl or Python, but whatever suits
your fancy should work (Visual
Tim Landscheidt wrote:
The main disadvantage in using a listener is that it is your
responsibility to make sure that the listener is listening
24/7 - from before the database accepts other connections,
through network failures, bugs, etc. - otherwise notifica-
tions will be lost. Therefore I
On Wednesday 12 August 2009 6:27:25 am Jan Verheyden wrote:
Hi,
I got a bit stuck...
I was looking for a solution for option a)
Maybe I'll first explain the situation a bit more:
I have one database for patient registration
Another one for image storage
And a third one for book keeping