[SQL] datestyle on windows environment: how to set?

[filippo]

Hello,

I want to set the datestyle = 'ISO, European' for all my databases. I
put that configuration into postgresql.conf file, but I didn't succeed.
After rebooting all dates are like that:

-MM-DD

I'd like to have

DD-MM- for my timestamp field.

I have the latest version of pgsql and perl.

Hereafter is an extract of my postgresql.conf file.

Thanks and best regards,
Filippo

# - Locale and Formatting -

datestyle = 'ISO, European'
#timezone = unknown # actually, defaults to TZ
# environment setting
#australian_timezones = off
#extra_float_digits = 0 # min -15, max 2
#client_encoding = sql_ascii# actually, defaults to database
# encoding

# These settings are initialized by initdb -- they might be changed
lc_messages = 'C'   # locale for system error message
# strings
lc_monetary = 'C'   # locale for monetary formatting
lc_numeric = 'C'# locale for number formatting
lc_time = 'C'   # locale for time formatting


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[SQL] join two tables with sharing some columns between two

[filippo]

Hi,

I have two tables like these: (this is an example, the actual tables
have diffferent fields and meanings)

TABLE1
id
person_name
date_arrival
date_departure

TABLE2
id
car_description
date_arrival
date_departure

I'd like to make a query to have such resulting table

RESULTING_TABLE
id
person_name
car_description
date_arrival
date_departure

the id is the primary key for the three tables and it's unique for the
three (id in table1 cannot be in table2, I use the same counter to
generate the id for table1 and table2).


I is possible to create such a query?

Thanks


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly