I doubt this is the right list, but it's the only one I'm subscribed to,
so please, if one of the core members is reading this, forward it to the
right one.
I have successfully compiled and installed 7.4.5 yesterday.
After doing 'make' I saw the line Ready to install.
template1=# select
I have a table
create table temp
(
tempdatetimestamp,
tempnamevarchar(10)
);
And I tried to insert the following:
insert into table temp (tempname, tempdate)
select distinct 'tempname', null from some_other_relevant_table;
And I got an error that says column
Dear All,
How to create Calendar using Function/View.
For example i would like to display date 2004-12-01
to 2004-12-20.
date
--
2004-12-01
2004-12-02
2004-12-03
2004-12-04
2004-12-05
..
..
2004-12-20
Hi,
I have a 14 million row table with one index on two fields one is a varchar
the other is a date. The combination of the two makes the row unique.
Data
-
name date... other fields
a 1/1/01
a 1/2/01
a 1/3/01
b 1/1/01
b 1/2/01
d 1/1/01
d 1/2/01
hi,
from mysql:
field enum('a','b','c') default null,
i translated this as:
field varchar(2) check (field in (null,'a','b','c')),
is it necessary to put the 'null' in the check condition? if not will pg
permit you to enter a null value in the field?
regards
kg
Wei,
insert into table temp (tempname, tempdate)
select distinct 'tempname', null from some_other_relevant_table;
I don't think you're reporting the error exactly as it happened. Try cutting
and pasting your actual PSQL session into your e-mail.
Perhaps you are mixing up the column order?
On Sat, Dec 11, 2004 at 03:26:33AM +0800, Muhyiddin A.M Hayat wrote:
How to create Calendar using Function/View.
For example i would like to display date 2004-12-01 to 2004-12-20.
You could write a function that returns SETOF DATE. Some sections
of the documentation you'll want to study
On Fri, 10 Dec 2004, Wei Weng wrote:
I have a table
create table temp
(
tempdatetimestamp,
tempnamevarchar(10)
);
And I tried to insert the following:
insert into table temp (tempname, tempdate)
select distinct 'tempname', null from
On Friday 10 December 2004 11:24 am, Wei Weng wrote:
I have a table
create table temp
(
tempdatetimestamp,
tempnamevarchar(10)
);
And I tried to insert the following:
insert into table temp (tempname, tempdate)
select distinct 'tempname', null from
