Re: [SQL] [pgsql-www] MySQL DB to PostgresSQL DB

node.net is an *excellent* resource. > > Thanks in advance. > > Jose > regards, J -- Jeff MacDonald Zoid Technologies, http://zoidtechnologies.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [SQL] execute client application from PL/pgSql

CTED] > Subject: Re: [SQL] execute client application from PL/pgSql > > Thank You Jeff, > What is phpPgAdmin and where can get it? > > Jack > > - Original Message - > From: "Jeff MacDonald" <[EMAIL PROTECTED]> > To: "Jack" <[EMAIL

Re: [SQL] execute client application from PL/pgSql

you could hack the pg_dump bit out of phpPgAdmin i think the license permits it. just my 2 cents. jeff On Wed, 9 May 2001, Jack wrote: > Date: Wed, 9 May 2001 09:45:46 +1000 > From: Jack <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: [SQL] execute client application from PL/pgSql > >

[SQL] "correct" sorting.

Hi folks, say i have a text field with teh values 1,2,3,10,20,30,1a,1b,2a,2b and i want to sort it so i get, 1 1a 1b 2 2a 2b 3 10 20 30 is there anyway to do that with postgresql ? below is what actually happens. jeff=> select * from foo order by var1; var1 -- 1 10 1a 1b 2 20 2a

[SQL] bug.. ?

ROUP BY port ORDER BY count(port) DESC > LIMIT 1' LANGUAGE 'sql'; > > The result: > ERROR: function declared to return int4 returns multiple values in final > retrieve > > > I'm running 7.0.2. Jeff MacDonald, --

[SQL] pl/Perl

uot;../../../src/Makefile.global", line 292: Missing dependency operator "../../../src/Makefile.global", line 294: Need an operator "../../../src/Makefile.global", line 296: Need an operator "../../../src/Makefile.global", line 299: Need an operator "../..

Re: [SQL] pl/Perl

using gmake instead of make (cd /usr/ports/devel/gmake, make) thanks ! works great. Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL PROTECTED] w

[SQL] substring ..

hi folks.. i want to do this to a datetime field.. select foo from table where substr(datefoo,1,11) = '2000-12-14'; it returns no results yet.. select substr(datefoo,1,11) does return some values that say 2000-12-14 any clues ? Jeff

Re: [SQL] substr

> Jeff MacDonald <[EMAIL PROTECTED]> writes: > > i noticed that substr behaves a bit different in pgsql than perl > > ie select foo from table where substr(foo,1,1) = 'X'; > > > just wondering on the reasoning for this offset ? > > Larry Wall a

[SQL] substr

i noticed that substr behaves a bit different in pgsql than perl ie select foo from table where substr(foo,1,1) = 'X'; initially i thought it should be substr(foo,0,1) just wondering on the reasoning for this offset ? Jeff

[SQL] Re: OID Perfomance - Object-Relational databases

e indexes are automatcally created on serials. > 2. Can I define my own index on the OIDs of a table? sure, create index oid_idx on table(oid); Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL

Re: [SQL] select

bingo, thaks On Sat, 23 Sep 2000, Stephan Szabo wrote: > > I'd assume this would work: > select * from table where booleanfield is null; > > Stephan Szabo > [EMAIL PROTECTED] > > On Sat, 23 Sep 2000, Jeff MacDonald wrote: > > > how would i select all

Re: [SQL] select

, Indraneel Majumdar wrote: > Hi, > > AFAIK, you can't enter a null value in a bool field, it has to be 1 or 0. > > \Indraneel > > On Sat, 23 Sep 2000, Jeff MacDonald wrote: > > > how would i select all rows where a boolean value is neither > > t

[SQL] select

how would i select all rows where a boolean value is neither t nor f.. ? ie if someone inserted without setting the boolean tag. Jeff MacDonald, - PostgreSQL Inc | Hub.Org Networking Services [EMAIL PROTECTED] | [EMAIL

[SQL] query failed , don't know why

UPDATE members m,payments p SET m.status = 2 WHERE p.paydate > 'now'::datetime - '1 month'::timespan and p.productid = 'xxx' and m.gid = p.gid i'm trying to run that query and i'm getting "parse error near m" but it looks ok to me i'm running postgresql 7.0.2 with freebsd 4.0 stable je

[SQL] timespan casting

hi, thought this up while playing with time spans.. here is my table and data.. bignose=> \d foo Table "foo" Attribute | Type| Modifier ---+---+-- start | timestamp | stop | timestamp | bignose=> select start,stop, stop-start as start_sto

Re: [HACKERS] Re: [SQL] 7.0 weirdness

thanks for the hlep guys.. for those that are curious, the distinct is tehr cause it's someone elses code that i'm workig on .. :) have to kick out the bug's// jeff On Tue, 30 May 2000, Matthias Urlichs wrote: > Hi, > > Jeff MacDonald: > > gid is unique.. it

Re: [SQL] 7.0 weirdness

same "gid" but different "created" fields in > your table . And PG does not know which one to select and compare for ORDER > BY clause. If that ,you would need to change the table structure to a better > normal form. > Regards , > Omid Omoomi > > > &

RE: [SQL] 7.0 weirdness

red > > Simple example > gid created > 11 > 13 > 22 > > In which order is Postgres supposed to give the data??? > > > Patrick Fiche > -Message d'origine----- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la

[SQL] 7.0 weirdness

hi folks, this query works fine in 6.5 but screwie in 7.0 7.0 gm=> SELECT DISTINCT gid FROM members gm-> WHERE active = 't' gm-> AND (gender = 0 gm-> AND (wantrstypemale LIKE '%Short Term%' gm-> OR wantrstypemale like '%Marriage%' gm-> OR wantrstypemal