"Richard Rowell" <[EMAIL PROTECTED]> writes:
> outer join syntax. MS has some nice syntactical sugar with the *=/=*
> operators that Postgres dosen't seem to support.
Some of us view it as "nonstandard and broken", not as "nice syntactical
sugar" ;-).
> I'm just not grasping how one would accom
Subject: [SQL] Outer Join Syntax
> I'm doing a feasability study on porting our flagship product to Postgres
> (from MS_SQL). I have run across a few snags, the largest of which is the
> outer join syntax. MS has some nice syntactical sugar with the *=/=*
> operators that Postgres dosen't seem
I'm doing a feasability study on porting our flagship product to Postgres
(from MS_SQL). I have run across a few snags, the largest of which is the
outer join syntax. MS has some nice syntactical sugar with the *=/=*
operators that Postgres dosen't seem to support. I am confused on how
to repli
> "Michael Richards" <[EMAIL PROTECTED]> writes:
>> The reduction of the list doesn't seem to be terribly efficient.
>> Here are some strategies I've been looking at:
>
>> select id from users WHERE
>> id not in (select userid from sentletters where lettertype=1) AND
>> aclgroup IN (1,2);
>
> Try
"Michael Richards" <[EMAIL PROTECTED]> writes:
> The reduction of the list doesn't seem to be terribly efficient. Here
> are some strategies I've been looking at:
> select id from users WHERE
> id not in (select userid from sentletters where lettertype=1) AND
> aclgroup IN (1,2);
Tom,
> regression=# select timestamp(996673954);
>timestamp
>
> 2001-08-01 09:52:34-04
> (1 row)
>
> (This last didn't use to work, but it seems fine in 7.0 and 7.1. It
> will fail in 2038 when timestamps stop looking like int4, but by then
> hopefully we'll ha
I've got 2 tables, one with a list of users (has only about 5000
entries) and another with a list of userids that have already been
sent letters. I'm trying to efficiently join these two so I get every
user who hasn't been sent a letter. The problem is, coupled with the
5 other joins on the us
"Richard Huxton" <[EMAIL PROTECTED]> writes:
>> I searched the docs for function to convert epoch to timestamps but
>> couldn't find any. Are there any?
> richardh=> select '1970-01-01'::date + '996654342 seconds'::interval;
> ?column?
>
> 2001-08-01 08:25:42+01
On Wed, Aug 01, 2001 at 09:28:39AM +0100, Richard Huxton wrote:
> Hi Roberto - long time no see.
Hey Richard. Yeah. Summer classes and summer jobs :-) I have to finish
my expanded "Porting From Oracle" thingy.
>
> richardh=> select '1970-01-01'::date + '996654342 seconds'::interval;
>
From: "Roberto Mello" <[EMAIL PROTECTED]>
Hi Roberto - long time no see.
> I searched the docs for function to convert epoch to timestamps but
> couldn't find any. Are there any?
richardh=> select now();
now
2001-08-01 09:25:58+01
(1 row)
richardh=> select e
10 matches
Mail list logo
