Title: Message
When i extract epoch
from field (timestamp(0) without time zone) I get the time that is set in
that field plus one hour...
Is that a bug or am
I just missing something
Regards,
Denis
Arh
On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote:
>I found this example in "Practical PostgreSQL"... will it do the job?
Answering my own question: kind of. The problem with custom aggregates
is that they need to be used with a "group by" clause, and this means
that the select cannot return co
Dear Sir/Madam,
I would like to find out two things:
1)Do you have a function which is similar to Oracle\'s DECODE.
2) Can you extract day of week (Monday,etc) from yours date functions.
Kind Regards,
Jack Kiss
---(end of broadcast)---
TIP 3: if po
--- Susan Hoddinott <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Having scoured the relevant documentation I cannot
> find anything which indicates how I simply create a
> database trigger to insert into a second table after
> insert on a first table, without the use of a
> procedure. As I do not want
On Tue, 2003-02-25 at 13:48, Edmund Lian wrote:
> On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote:
>
> >I found this example in "Practical PostgreSQL"... will it do the job?
>
> Answering my own question: kind of. The problem with custom aggregates
> is that they need to be used with a "group
On Tue, 2003-02-25 at 13:48, Edmund Lian wrote:
> On Tue, 25 Feb 2003 03:44:02 GMT, Edmund Lian wrote:
>
> >I found this example in "Practical PostgreSQL"... will it do the job?
>
> Answering my own question: kind of. The problem with custom aggregates
> is that they need to be used with a "group
On Tue, Feb 25, 2003 at 15:25:17 +0100,
Natasa Bulatovic <[EMAIL PROTECTED]> wrote:
>
> select col1||col2||col3||.||col100 from table
>
> Most of these columns for the test data are NULL...Datatypes of columns are mixed
> text, varchar, char...Select statement does not return any error...J
On Sat, Mar 01, 2003 at 19:53:27 +0100,
Nicolas Fertig <[EMAIL PROTECTED]> wrote:
>
> I want to have all the row in table "table_main" with the value in the table
> "table_slave" (value or null if not exist)
>
> It is possible to have the same result without sub-select in OUTER JOIN
> (speed pr
On Tue, 25 Feb 2003, Natasa Bulatovic wrote:
> Select statement returns as a result concatenated all varchar, text
> and char columns of a table as one single column ...
>
> select col1||col2||col3||.||col100 from table
>
> However, when the number of concatenated columns is bigger than 22 no
