Ignored PostgreSQL SET command

From: "Patrick Dunford" <pdunford(dot)webs(at)clear(dot)net(dot)nz>
To: "PostgreSQL List" <pgsql-hackers(at)postgresql(dot)org>, <php-general(at)lists(dot)php(dot)net>
Subject: Ignored PostgreSQL SET command
Date: 2001-01-02 04:14:02
Message-ID: 000701c07472$7045f2e0$3acda7cb@patrickspc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a line in a PHP script that looks like this:

$set=pg_exec($dbconn, "SET DATESTYLE TO 'European'"); //Set date format

Since my ISP updated their server, this appears to be ignored as pgsql
always returns dates in ISO format.

1. What is the default format of dates returned that I can ALWAYS rely on?

2. Why is the command ignored?

=======================================================================
Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/

There is no wisdom, no insight, no plan that can succeed against
the LORD.
-- Proverbs 21:30
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010101
=======================================================================
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-01-02 04:59:56 Re: PHP and PostgreSQL
Previous Message Rod Taylor 2001-01-02 04:08:16 Re: PHP and PostgreSQL