Dear All,
My Name is Nugon, I am just a beginner in pgsql, now I
am using pgsql 8.0.3 win32 platform. There are several
problem or issue for me, any help/answer/advice very
helpfull for me :
= how to get raise notice messages at client database
API such as ODBC, ADO, DAO, RDO or client programming
What the heck are you talking about? It was a brand new subject, it was
not part of any thread.
A. Kretschmer wrote:
am 19.08.2005, um 11:34:52 -0500 mailte Tony Caduto folgendes:
Is it possible to write c style functions with Free Pascal?
Please, if you open a new subject, then
Tony Caduto <[EMAIL PROTECTED]> writes:
> What the heck are you talking about? It was a brand new subject, it
> was not part of any thread.
It had a References: header referring to a previous message. Most
mailers will honor this even if th esubject changes, and keep the
message in the existing
On Sat, Aug 20, 2005 at 09:00:56AM -0500, Tony Caduto wrote:
> What the heck are you talking about? It was a brand new subject, it was
> not part of any thread.
Are you starting new threads by replying to messages and then
changing the subject? The References and In-Reply-To headers in
your mes
On Fri, Aug 19, 2005 at 03:01:38PM -0700, Nugroho Laison wrote:
> = how to get raise notice messages at client database
> API such as ODBC, ADO, DAO, RDO or client programming
> such as PHP, JSP, C/C++, Java?
You'll have to consult the interface's documentation. For example,
for C see the "libpq
Hi,
I want to select records that haven't had an error
(logged to last_error) in the last 24 hours. My query
is:
select * from table1
where last_error is null
or extract(epoch from now()-last_error) > 86400;
I've created an index on last_error (timestamp with
time zone - can be NULL), then used
On Sat, 2005-08-20 at 15:33 -0700, CSN wrote:
> Hi,
>
> I want to select records that haven't had an error
> (logged to last_error) in the last 24 hours. My query
> is:
>
> select * from table1
> where last_error is null
> or extract(epoch from now()-last_error) > 86400;
I don't know whether the
The extract (dow from date) function returns 0 for Sunday (nice).
My problem is that Sunday is the last day of the week according to
extract (week from date). Is it the expected behavior?
teste=# create table dates (date timestamp);
CREATE TABLE
teste=# insert into dates values ('2005-08-08');
IN
Uh, you are ordering by 'date', not column 3, try ORDER BY 3.
---
Clodoaldo Pinto wrote:
> The extract (dow from date) function returns 0 for Sunday (nice).
>
> My problem is that Sunday is the last day of the week accordin
Oliver Elphick writes:
> On Sat, 2005-08-20 at 15:33 -0700, CSN wrote:
>> select * from table1
>> where last_error is null
>> or extract(epoch from now()-last_error) > 86400;
> I don't know whether the planner would recognise that it could use an
> index on that condition.
The "is null" isn't in
2005/8/20, Bruce Momjian :
>
> Uh, you are ordering by 'date', not column 3, try ORDER BY 3.
>
I'm ordering by date just to show that sunday, the 0th day of the
week, is the last day of a given week, which is not what I need.
I'm migrating a site from mysql to postgres and the logic of the tabl
On Sat, Aug 20, 2005 at 09:03:32PM -0400, Bruce Momjian wrote:
>
> Uh, you are ordering by 'date', not column 3, try ORDER BY 3.
I think the point is that extract(week) is inconsistent with
extract(dow) with respect to what week a sunday is on.
> Clodoaldo Pinto wrote:
> > The extract (dow from
On Sat, 20 Aug 2005, Bruce Momjian wrote:
> Uh, you are ordering by 'date', not column 3, try ORDER BY 3.
That's not really the issue. The issue is that our definition of date of
week and week of year are somewhat inconsistent with each other. We appear
to be doing week of year per ISO-8601, bu
Clodoaldo Pinto <[EMAIL PROTECTED]> writes:
> I'm ordering by date just to show that sunday, the 0th day of the
> week, is the last day of a given week, which is not what I need.
extract(week) follows the ISO definition of week, which is pretty
strange anyway, but in particular it says that weeks
Dear Postgresql specialists
I would like to seek help with problems I am experiencing with the
COPY command.
We have a user whose 3rd party software exports text data in CSV
format.
The Postgresql import function COPY supports CSV but fails when
importing the data.
I have studied in the Postgre
On Sun, Aug 21, 2005 at 02:33:53PM +1200, Bernard wrote:
> The Postgresql import function COPY supports CSV but fails when
> importing the data.
This problem was fixed about a week after 8.0.3 was released:
http://archives.postgresql.org/pgsql-committers/2005-05/msg00168.php
The developers have
On Sat, 20 Aug 2005, Tom Lane wrote:
> Clodoaldo Pinto <[EMAIL PROTECTED]> writes:
> > I'm ordering by date just to show that sunday, the 0th day of the
> > week, is the last day of a given week, which is not what I need.
>
> extract(week) follows the ISO definition of week, which is pretty
> stra
On Sat, Aug 20, 2005 at 08:49:27PM -0700, Stephan Szabo wrote:
> On Sat, 20 Aug 2005, Tom Lane wrote:
>
> > Clodoaldo Pinto <[EMAIL PROTECTED]> writes:
> > > I'm ordering by date just to show that sunday, the 0th day of the
> > > week, is the last day of a given week, which is not what I need.
> >
18 matches
Mail list logo
