> On Wed, Jul 30, 2003 at 01:11:35PM -0700, Eric Clark wrote:
> > On Wed, 2003-07-30 at 12:35, Dave Dribin wrote:
> > > CREATE TABLE cd (
> > > id integer unique,
> > > artist varchar(25),
> > > title varchar(25)
> > > );
> > >
> > > CREATE TABLE cd_genres (
> > > cd_id integer,
> > > genre varchar
Hi
all!
Who can tell me what postgres version supports
ALTER TABLE... DROP CONSTRAINT without
the need
of droping the table to remove a simple coinstraint.
(link)
>\\\!/< 55
11 5080
9283
Title: Urgent Help : Use of return from function/procedure.
- Original Message -
From:
Anagha
Joshi
To: [EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 11:42
PM
Subject: [SQL] Urgent Help : Use of
return from function/procedure.
Hi, I'm new to
postgres and
I see your post. But no others since Monday.
Thanks
Chad
- Original Message -
From: "Achilleus Mantzios" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 5:39 AM
Subject: [SQL] To ListAdms: Is pgsql-sql operating?
>
> Is there any problem with [EMAIL PROTECTED
>
> I guess it's a little unclear what to print for the first number when no
> rows are output at all. The code evidently is using the total time spent
> in the plan node, but I think it would be at least as justifiable to
> print a zero instead. Would you have found that less confusing? Anyone
I have never been very good at reading these query plans, but I have a bit
of a problem w/ my query. So any help is appreciated.
The query is fairly self explanitory i think. 2 tables, call_results ( 6.5
Million records ) and lists ( 11 Million records )
weblink=# explain analyze
weblink-# selec
The assumtion that char and varchar can be compared is gone. Any comparison
or in this case concatination between the two types needs to be explicitly
cast.
try
SELECT code::varchar || ' ' || diag::varchar, code
FROM dsm4
WHERE axis = 1
ORDER BY code;
Thanks
Chad
- Original Message -
Fro
> On 21 Feb 2003 at 13:00, Chad Thompson wrote:
>
>
> > > On 21 Feb 2003 at 19:18, Gaetano Mendola wrote:
> > >
> > > > > Hi folks,
> > > > >
> > > > > This query:
> > > > >
> > > > > SELECT el
> On 21 Feb 2003 at 19:18, Gaetano Mendola wrote:
>
> > > Hi folks,
> > >
> > > This query:
> > >
> > > SELECT element_id as wle_element_id, COUNT(watch_list_id)
> > > FROM watch_list JOIN watch_list_element
> > > ON watch_list.id = watch_list_element.watch_list_id
> > >
Found this using google
from http://archives.postgresql.org/pgsql-sql/2002-01/msg00312.php
Depending on what you're doing (and if you're willing to work with
the7.2rcs or wait for it), 7.2 allows you to define functions that
returncursors that you can then fetch from within the transaction y
>
> Unix EOL is LF not CR.
>
>
Is this the only difference between a dos and unix text file?
Thanks
Chad
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
This should be all you need.
insert into VisitorPointer839 ("VisitorID")
select VisitorID
from ProgramEvent
Where ProgramID = 10
and Type = 0
group by VisitorID
You dont need order by because its not important the order it goes in the
database, just the order that it comes out.
I have found that
"subscript out of range" is an error that means you are trying to access
part of an array that doesnt exist.
It probably means that your data doesnt have all the fields for all the
records.
Check to see if your data is truncated or if there is an unusual (usually
shortened) number of fields in a g
select first(a) from ta order by a
in access, is equivilent to
select a from ta order by a limit 1
Thanks
Chad
P.S. Note that access will always return the same value if you exclude the
order by, this is not necessarily true with postgresql or any real RDBS.
- Original Message -
From:
:
Michelle Murrain
To: Chad Thompson ; Waheed Rahuman ;
[EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 8:48
AM
Subject: Re: [SQL] Please Help me
At 8:32 AM -0600 8/1/02, Chad Thompson wrote:
I am running
RedHat, with Apache and Cold Fusion. I chose PostgreSQL for
I am running RedHat, with Apache and Cold
Fusion. I chose PostgreSQL for all of the aforementioned reasons. It
works very well with Cold Fusion. I have done some optimizing and am able
to run rather complex queries much faster than I ever was able to on any Windows
platform database. I h
Is there any way to automaticly "seed" a number
into a list. For example
create table "temp"(
select distinct(full_phone)
from lists
where client_id =8)
This gives me 100,000 unique records
What i would like to do is, every 2500, insert a
specific number like '5552552555'
can this be
17 matches
Mail list logo
