On Fri, 26 May 2000, Sherril Mathew wrote:
My one feild in the database is Date/time I want to find a range of
records which exists between two dates in the same date field in the
database
SELECT * FROM table WHERE datetime_field between '1999-03-15' and
'2000-10-23';
Also tell me how
Markus Wagner wrote:
Hi,
I am using PG 6.5.1 and DBI. My Perl programs always print to stderr:
"NOTICE: UserAbortTransactionBlock and not in in-progress state" or
"NOTICE: EndTransactionBlock and not inprogress/abort state"
I tried to do stmthandle - finish and dbhandle - commit
Markus Wagner [EMAIL PROTECTED] writes:
I am using PG 6.5.1 and DBI. My Perl programs always print to stderr:
"NOTICE: UserAbortTransactionBlock and not in in-progress state" or
"NOTICE: EndTransactionBlock and not inprogress/abort state"
I tried to do stmthandle - finish and dbhandle -
Peter Eisentraut [EMAIL PROTECTED] writes:
Once again, I think that we *really* need to discuss whether implicit
range table entries in SELECT are a good idea. We invariably get a
question like this every week and invariably the answer is "if you give a
table an alias you *must* refer to it
- Original Message -
From: Ed Loehr [EMAIL PROTECTED]
To: Peter Landis [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 26, 2000 5:35 PM
Subject: Re: [SQL] POSTGRESQL and PERL?
Peter Landis wrote:
but what if you have a variable set like:
$sort_selection = "name";
Peter Eisentraut wrote:
playpen= select ta.a,ta.b,ta.c, (select count (tb.zz) where tb.yy =
ta.a) from tablea ta, tableb tb order by tablea.a;
[ produces 80 rows ]
playpen= select ta.a,ta.b,ta.c, (select count (tb.zz) where tb.yy =
ta.a) from tablea ta, tableb tb order by ta.a;
I have a piece of commercial software that does a query like so:
CREATE TABLE chargelimits (id int NOT NULL, user_id int NOT NULL, limit
float NOT NULL )
but the postgresql 7.0 gives a parse error near "limit".
Is limit a reserved keyword?
If so, then it is not in the list of reserved keywords.