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,
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 particularly
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 academic terms,
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.
---
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
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 that
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
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).
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
-
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's driving me nuts. I have a table
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
11 matches
Mail list logo