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 EnterpriseD

[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 a