Re: [SQL] Funny date-sorting task

2007-05-12 Thread Frank Bax
At 07:40 PM 5/12/07, Andreas wrote: I've got a stack of tasks to show in a list. Every task has a timestamp X that may be NULL or a date. It contains the date when this tasks should be done. Sometimes it has date and the time-part, too. The list should be like this: 1) X sometime today s

[SQL] Funny date-sorting task

2007-05-12 Thread Andreas
Hi, I've got a stack of tasks to show in a list. Every task has a timestamp X that may be NULL or a date. It contains the date when this tasks should be done. Sometimes it has date and the time-part, too. The list should be like this: 1) X sometime today should come first in ascending ti

[SQL] Howto convert / (re)store xml column to table in trigger using contrib/xml2?

2007-05-12 Thread Joost Kraaijeveld
Hi, Is it possible to convert / (re)store a column that contains xml (see below) into real table in a trigger, using contrib/xml2? The reason is that an application stores a xml blob in a column but we need the data in a real table for a third party report generator. So I want to use a trigger th