[SQL] dblinks

2008-05-17 Thread sumaya 
Hi,

I am accessing data across different databases using dblinks but the dates are 
getting messed up:
table: mytable
columns: my_id int
my_date date
values: 1
2008-04-09

When retrieving data from the table in the relevant database the date is 
returned correctly: 2008-04-09
but when retrieving across dblinks using statement below, I get the following 
error:
statement looks like

select * from [EMAIL PROTECTED];

the error refers to the datestyle setting and shows the date as '2008-09-04'

Please advise if there is a way around this.

Thanks,
Sumaya

Re: [SQL] dblinks

2008-05-17 Thread Jonah H. Harris 
On Sat, May 17, 2008 at 6:58 PM,  <[EMAIL PROTECTED]> wrote:
> statement looks like
> select * from [EMAIL PROTECTED];

Postgres does not support this style of database link syntax.  Are you
using Oracle or EnterpriseDB?

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | [EMAIL PROTECTED]
Edison, NJ 08837 | http://www.enterprisedb.com/

-- 
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql