To update all existing records with empty values:
update table1
set datefield = null;
To insert an empty value into a new record:
insert into table1 (datefield) values (null);
Best of luck,
Andrew Gould
--- kingking <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> How to store empty to Date f
I have a function f1 with two parameters, par1 and par2. f1 creates another
function with name=par1 and type=par2.
How can I test if EXECUTE was successful or not, because I want f1 to return
a boolean that shows whether the creation of the new function was
successful or not.
--
I think this will be fixed in 7.2 because we have more cidr/inet
comparison operators.
> Try this:
>
> create table interface ( mac macaddr, primary key(mac) );
>
> insert into interface (mac) values ('00:11:22:33:44:55');
> insert into interface (mac) values ('00:11:22:33:44:5a');
> insert in
I think you are supposed to escape placeholder markers by doubling them: ??
should be effectively changed to '?' before passed to PG. I haven't come
across this yet, but I think that's the correct (although undocumented)
syntax.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better I
Sorry if it posts twice, the first one seems to have vanished...
I have a function f1 with two parameters, par1 and par2. f1 creates another
function with name=par1 and type=par2.
How can I test if EXECUTE was successful or not, because I want f1 to return
a boolean that shows whether the creation
Unfortunately, PG does not have any sense of an "empty" date. It must either
be valid or NULL.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
> From: "kingking" <[EMAIL PROTECTED]>
> Organization: Hub.Org Networking Services (http://www.hub.org)
> Date: Tue, 25 Sep
> >(Not to mention the fact that IDE drives only do well when a single
> > process is accessing them. SCSI, having been designed from the gound up
> > for this sort of thing, does much better when you're hitting the disks
> > from several places at once.)
>
>
> Do you have any hard data to
How can I test that a text variable has a value that represents a valid data
type, other than writing something like: variable IN ('integer', 'text',
'float'...)?
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postg
Sorry if it double posts, the first one seems to have vanished...
How can I test that a text variable has a value that represents a valid data
type, other than writing something like: variable IN ('integer', 'text',
'float'...)?
---(end of broadcast)-
> Is there any way of reading the whole database into memory? By changing
> the
> number of shared buffers the first query still takes long time and the
> subsequent similar queries are fast.
> If there is way of pinning the database in the memory all similar
> queries will take the same time. My
> What I said: "SCSI disks cost a lot more than comparable IDE disks."
>
> What you said: "No, because I found some cheap SCSI disks that
> don't have comparable IDE models."
That's not what I said. If you're going to quote me, get it right.
> My statement only operates in the domain where
>
On 20 Sep 2001, Alex K. wrote:
> create table USERS (
> ID decimal(19) CONSTRAINT primary_usr_oid
> PRIMARY KEY,
> WRITE_COUNT decimal(19) NOT NULL,
> CLASS decimal(10) NOT NULL,
>
recently did another installation on a FreeBSD/Apache web server. Am getting
startup failures on postgres (not sure what I did different from our other
server).
It complains it is missing some SSL files (server.crt and key) and is prompting
for those to be in the created data directory. As a si
Is 'varchar2' a proper user-defined type?
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
> From: [EMAIL PROTECTED] (Alex K.)
> Organization: http://groups.google.com/
> Date: 20 Sep 2001 15:18:46 -0700
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] what is wrong with
Dear all,
We had been using a postgresql version 6.0 since 1997. I have recently
decided to go to the most recent version 7.1.3. I am under Solaris 2.6. The
installation was OK, but after restoring the database. I have been surprised
by the poor performance of the new version.
Going a litte deep
Is there any way of reading the whole database into memory? By changing
the
number of shared buffers the first query still takes long time and the
subsequent similar queries are fast.
If there is way of pinning the database in the memory all similar
queries will
take the same time.
thanks
--
hi,
does anyone know if there exists a Postgres function to extract the integer
portion of a text string?
e.g.
somefunc('109PL') --> 109
somefunc('Plot Number 106') --> 106
TIA,
ben
--
ben ausden
developer, navyblue new media
[t] 0131 553 0100
[f] 0131 553 1303
[e] benedict{at}navyblue.c
Is there any way of reading the whole database into memory? By changing
the
number of shared buffers the first query still takes long time and the
subsequent similar queries are fast.
If there is way of pinning the database in the memory all similar
queries will take the same time. My database is
Hello all,
I am working on a function to determine the date of the first saturday of
the month.
Currently I have:
CREATE FUNCTION first_saturday(date)
RETURNS date
AS '
Select CASE WHEN date_part(\'dow\',\'$1\'::DATE)=0 THEN date(\'$1\')+6
WHEN date_part(\'dow\',\'$1\'::DATE)=1 THEN date(\'$1\
can iknow is there any replacement for a cursor in postgresql if soon
please send me the information as soon as u can.waiting for ur reply.
cheers
chowdary.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--- Tom Ince <[EMAIL PROTECTED]> wrote:
> I am attempting to convert an database currently running on
> Informix to
> a free database on Linux (RedHat 6.1). I have a question.
>
> I learned that MySQL, does not maintain foreign keys, which
> affects me
> because I need to use things like CH
i need an exact way how to pass an array and retrieve an array from a
function .i encountered many problems while trying this ,if possible
please guide me with a example.
cheers
chowdary.
---(end of broadcast)---
TIP 5: Have you checked our extensiv
Hi
I'm tearing my hair out here, the backend seems to randomly decide to stall
and not serve any more queries (processes are listed as waiting).
It happens on all sorts of queries (including CREATE TABLE and CREATE INDEX).
I have completely uninstalled and deleted the whole installation and
r
On Thu, Sep 20, 2001 at 11:10:02AM +0200, Herbert Liechti wrote:
> I tried it. See my actions below. The main performance boost is
> reached by creating an index and disabling the sequential scan:
> Without any index;
> real0m18.128s
> user0m0.010s
> sys 0m0.010s
>
> Same statement wi
You need a left outer join:
select name, count(sales.client_id) from clients left outer join sales on
sales.client_id = clients.id group by name;
Outer joins were not supported prior to 7.1, so if you're using an earlier
version, you'll want to either upgrade or read the docs for your version;
Hmmm... I'm using 7.1.2, and don't know if you should upgrade or not.
Can you use UNIONs?
select name, count(client_id) from sales, clients where client_id = id group
by name UNION select name,0 from clients where not id in (select client_id
from sales) order by 2;
Yes, when I said "Try a lef
I am in the process of trying to convince a Microsoft SQL Guy, that Postgres is what
we need to look at, for replacing one of our OTHER ($$) databases. He wants to go
with SQL Server. One of his arguments is that PostgreSQL functions don't return
Record Sets. Is this true, or can functio
Janning Vygen <[EMAIL PROTECTED]> writes:
> ERROR: OUTER JOIN is not yet supported
> (PostgreSQL) 7.0.3
>
> do i need to upgrade or is there a workaround??
7.1 introduced support for outer joins.
-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she sa
I am attempting to convert an database currently running on Informix to
a free database on Linux (RedHat 6.1). I have a question.
I learned that MySQL, does not maintain foreign keys, which affects me
because I need to use things like CHECK in the CREATE TABLE statements.
So thats why I am
Am Donnerstag, 27. September 2001 17:47 schrieb David Christian:
> Hmmm... I'm using 7.1.2, and don't know if you should upgrade or
> not.
>
> Can you use UNIONs?
>
> select name, count(client_id) from sales, clients where client_id =
> id group by name UNION select name,0 from clients where not
Am Donnerstag, 27. September 2001 17:18 schrieb David Christian:
> Try a left join:
>
> select name, count(client_id) AS cnt from clients left join sales
> on (client_id = id) group by name order by cnt;
# select name, count(client_id) AS cnt from clients left join sales on
(client_id = id) group
Try a left join:
select name, count(client_id) AS cnt from clients left join sales on
(client_id = id) group by name order by cnt;
There's a great book for SQL called "The Practical SQL Handbook" which
covers these types of problems well. Published by Addison Wesley, written
by Bowman, Emerson,
The lib dir holds files to help us interface languages..
Some of the names seem obvious to me but are
the following for Perl
libpg.solipg.a libpg.so.2
And if not what are Perl files?
Lastly if the make did not install the files
as I got one message during make declaring
lack of SHARED
I need some help please,
i am having two simple tables:
# select * from sales;
client_id | product
---+-
1 | toolbox
1 | nails
2 | nuts
# select * from clients;
id | name
+---
1 | peter
2 | john
3 | marc
now i want
34 matches
Mail list logo
