On 4/11/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hi all,
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
and I need an SQL query such that for any given term I want to find the
next term by s
Merlin Moncure escribió:
> my suggestion to return the record in a field as a composite type is a
> non-standard trick (i think...do composite types exist in the sql
> standard?).
I think composite types are in the standard, yes, but they are a bit
different from what we have. I tried to read th
On 4/12/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
On 12/04/2007 18:01, Merlin Moncure wrote:
> I tested it and this is much faster than 'where exists' solution.
Is this an attribute of PostgreSQL in particular, or would it be true of
RDBMSs in general?
evaluation of subqueries is one p
On 12/04/2007 18:01, Merlin Moncure wrote:
I tested it and this is much faster than 'where exists' solution.
Is this an attribute of PostgreSQL in particular, or would it be true of
RDBMSs in general?
Thanks again,
Ray.
---
Raymo
On 4/12/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 4/12/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 11/04/2007 21:15, Jon Sime wrote:
>
> >> This is probably a very simple one, but I just can't see the answer and
> >> it's driving me nuts. I have a table holding details of academi
On 4/12/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
On 11/04/2007 21:15, Jon Sime wrote:
>> This is probably a very simple one, but I just can't see the answer and
>> it's driving me nuts. I have a table holding details of academic terms,
Many thanks indeed to all who replied - I particula
On 11/04/2007 21:15, Jon Sime wrote:
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
Many thanks indeed to all who replied - I particularly like Jeff's
solution, and will use that one.
Regards,
Raymond O'Donnell wrote:
> This is probably a very simple one, but I just can't see the answer and
> it's driving me nuts. I have a table holding details of academic terms,
> and I need an SQL query such that for any given term I want to find the
> next term by starting date (or just NULL if there
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Raymond
O'Donnell
Sent: Wednesday, April 11, 2007 3:40 PM
To: 'PostgreSQL'
Subject: [GENERAL] SQL - finding next date
Hi all,
This is probably a very simple one, but I just can't see the answer and
it'
sidy
Raymond O'Donnell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/11/2007 12:41 PM
Please respond to
[EMAIL PROTECTED]
To
'PostgreSQL'
cc
Subject
[GENERAL] SQL - finding next date
Hi all,
This is probably a very simple one, but I just can't see the
On 4/11/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hi all,
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
and I need an SQL query such that for any given term I want to find the
next term by s
Hi all,
This is probably a very simple one, but I just can't see the answer and
it's driving me nuts. I have a table holding details of academic terms,
and I need an SQL query such that for any given term I want to find the
next term by starting date (or just NULL if there isn't one).
Here's
12 matches
Mail list logo
