Greetings,
great thanks to Oleg Broytmann for his useful advice, I've
understood the proper fromat for input data at last and the
problem with copying DB from file was successfully solved.
Well, I hope you will not be angry with me for one more
(and I want belive the last) lame question:
Hi,
I'm running PostgreSQL 6.3.2. on SPARC Solaris 2.6.
I have several Web applications that I run under
mod_perl, using Apache::DBI to achieve persistent
database connections. I now have three databases
that connect on initialisation when Apache starts
up, which essentially means each Apache
> SR> Dear All,
> SR> For those of you who don't want to wade through the details, here's the
> SR> question: "How do I get the date portion of a datetime field for ALL
> SR> ENTRIES in a table regardless of whether the entry is NULL or not? (N.B.
> SR> Typecasting a datetime NULL as date generate
> "WC" == Wim Ceulemans <[EMAIL PROTECTED]> writes:
WC> I find the above interesting and I've tried something similar that won't
WC> work.
WC> I have two tables defined as follows
WC> create table test1 (id1 int,link1 int);
WC> create table test2 (id2 int, field2 varchar(5));
WC> whe
>There are, on my mind, at least two answers. For experience I use
>small table 'create table a( dt datetime, i int)'. Hera are data in
>this table (one row has NULL as dt value):
>
>tolik=> select * from a;
>dt | i
>+--
>Thu Nov 26 16:35:23 199
> "SR" == Stuart Rison <[EMAIL PROTECTED]> writes:
SR> Dear All,
SR> For those of you who don't want to wade through the details, here's the
SR> question: "How do I get the date portion of a datetime field for ALL
SR> ENTRIES in a table regardless of whether the entry is NULL or not? (N.B
