Re: [SQL] it's not NULL, then what is it?

Just out of curiosity did you try maf = 0? Edward W. Rouse From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Tena Sakai Sent: Tuesday, June 30, 2009 6:03 PM To: pgsql-sql@postgresql.org Subject: [SQL] it's not NULL, then what is it? Hi Ever

[SQL] lost password

a forgotten password? Edward W. Rouse Comsquared System, Inc. 770-734-5301

Re: [SQL] lost password

e md5. It was different, but I could still use the same password to log in. Needless to say, I am a bit confused by that, but it works and that's what I need. Edward W. Rouse From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Edward W. Rouse Sen

Re: [SQL] lost password

g. But my original problem is solved in either case, so it doesn't really matter to me. I just found it to be ... interesting. Edward W. Rouse -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Tom Lane Sent: Tuesday, November 17,

[SQL] Duplicate rows

Is there any way to remove a duplicate row from a table? Not my db but I have to work with it. On version 7.4 right now. Edward W. Rouse Comsquared System, Inc. 770-734-5301

Re: [SQL] Duplicate rows

nction matches the given name and argument types. You may need to add explicit type casts. I appreciate all the help and this feels like I'm almost there. Thanks Edward W. Rouse -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf

Re: [SQL] Duplicate rows

Solved. Because this is a 7.4 version and we used with oids by default, I can use the oids instead of the ctid to remove the duplicates. Thanks. Edward W. Rouse -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Edward W. Rouse

Re: [SQL] Issue with postgres connectivity

When was the last time you did a vacuum analyze? Edward W. Rouse -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Arindam Hore Sent: Friday, January 21, 2011 6:44 AM To: Reinoud van Leeuwen; pgsql-sql@postgresql.org Subject: Re

Re: [SQL] Sorting Issue

Looks like the sort is removing the spaces before sorting. cxh cxlm cxlp etc... Edward W. Rouse -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Ozer, Pam Sent: Monday, May 09, 2011 3:39 PM To: em...@encs.concordia.ca Cc

Re: [SQL] extracting location info from string

data and is easier to modify in the future. Edward W. Rouse -Original Message- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Lew Sent: Monday, May 23, 2011 12:25 AM To: pgsql-sql@postgresql.org Subject: Re: [SQL] extracting location info from

Re: [SQL] Stuck Up In My Own Category Tree

How about SELECT cat_name, sum(amount) AS "amount" FROM category, trans_details WHERE category_cat_id in (select cat_id from category where lineage ~ '^1') Where the in clause is basically, the cat_id where lineage starts with, and then the lineage you want. 1, 1-2, whatever the lineage is. Not

[SQL] intervals

hat someone on the list has probably done this already. I may, in fact, be doing it entirely wrong. So if someone knows the correct/better/easier way to create a dynamic interval I'd appreciate a clue. Thanks. Edward W. Rouse -- Sent via pgsql-sql mailing list (pgsql-sql@postgresq

Re: [SQL] intervals

That was part of the problem. Thanks for the info. > -Original Message- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of Jonathan S. Katz > Sent: Thursday, November 03, 2011 1:41 PM > To: Edward W. Rouse > Cc: pgsql-

Re: [SQL] intervals

e the easy part. Thanks. > -Original Message- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of bricklen > Sent: Thursday, November 03, 2011 1:44 PM > To: Edward W. Rouse > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] in

[SQL] must appear in the GROUP BY clause or be used in an aggregate function problem

ed putting in a dummy value like the date for an invoicenum, but that works as well as I expected it would (not at all). Edward W. Rouse -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] must appear in the GROUP BY clause or be used in an aggregate function problem

thing with the way the table are joined perhaps? Can I remove the joins and put the a.id = c.id in the where clause and get rid of this? From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Samuel Gendler Sent: Tuesday, January 31, 2012 3:57 PM To: Edward W. Rou

Re: [SQL] must appear in the GROUP BY clause or be used in an aggregate function problem

lf Of Edward W. Rouse Sent: Tuesday, January 31, 2012 4:27 PM To: 'Samuel Gendler' Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] must appear in the GROUP BY clause or be used in an aggregate function problem I would love to remove most of the aggregate functions. I am trying to update an

Re: [SQL] must appear in the GROUP BY clause or be used in an aggregate function problem

quire otherwise. My code is boring, but easy to understand and maintain ;) From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Samuel Gendler Sent: Tuesday, January 31, 2012 4:52 PM To: Edward W. Rouse Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] must appear i

[SQL] time interval math

nd format (I am assuming from current data that, after the divide, the result should be in the minute: second range). Edward W. Rouse Comsquared System, Inc. 770-734-5301 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [SQL] time interval math

3600 + ":" + a / 60 + ":" + a % 60) > -Original Message- > From: Steve Crawford [mailto:scrawf...@pinpointresearch.com] > Sent: Wednesday, February 08, 2012 3:26 PM > To: Edward W. Rouse > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] time inter

Re: [SQL] time interval math

> -Original Message- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of Jasen Betts > Sent: Thursday, February 09, 2012 6:37 AM > To: pgsql-sql@postgresql.org > Subject: Re: [SQL] time interval math > > On 2012-02-08

[SQL] pg_dump - 8.3 - schemas

=reports, I only get the reports schema. Is there a way to get all the schemas from a single pg_dump or am I forced to use separate ones? This is also for future issues where there may be more than 2. Thanks Edward W. Rouse -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make

Re: [SQL] pg_dump - 8.3 - schemas

To answer the second question first, yes; both as the same user. pg_dump -v -f $bkfile -F c -U $USER $DATABASE > -Original Message- > From: Adrian Klaver [mailto:adrian.kla...@gmail.com] > Sent: Thursday, February 16, 2012 2:22 PM > To: Edward W. Rouse > Cc: pgsql-sql

Re: [SQL] pg_dump - 8.3 - schemas

-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of Adrian Klaver > Sent: Thursday, February 16, 2012 2:39 PM > To: Edward W. Rouse > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] pg_dump - 8.3 - schemas > > On 02/16/2012 11:31 AM, Edward W. Rous

[SQL] ignore case in where clause

ise, to do case insensitive matching? I could spend a few hours testing if I have to, but I'm hoping someone knows off the top of their heads. Using 8.3 currently. I am a programmer, not a database person; but we don't really have a DB here, so I do what I can. Thanks. Edward W. Rouse Co

Re: [SQL] ignore case in where clause

That was exactly it, Thanks. > -Original Message- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of Guillaume Lelarge > Sent: Thursday, March 22, 2012 4:39 PM > To: Edward W. Rouse > Cc: pgsql-sql@postgresql.org > Subject:

[SQL] copy users/groups

nd restore them without overwriting what's been manually added to the new database? Edward W. Rouse -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] removing duplicates and using sort

Change the order by to order by lastname, firstname, refid, appldate From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Nathan Mailg Sent: Saturday, September 14, 2013 10:36 PM To: pgsql-sql@postgresql.org Subject: [SQL] removing duplicates and using sort

[SQL] problem with join

I have 2 tables that look like this: table1 table2 - value1 | value2 value1 | value3 | value4 - one| a one| a | jim one| b one| d | bob one| c

[SQL] group by day

get a count per day such that the result would be something like datecount 01-may-2007107 02-may-2007215 03-may-200796 04-may-20070 I would prefer the 0 entries be included but can live without them. Thanks. Oh, postgres 7.4 by the wa

Re: [SQL] duplicate key violates unique constraint

Could it be that the insert statement itself is the problem? What does the table look like? Edward W. Rouse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bart Degryse Sent: Tuesday, February 26, 2008 11:35 AM To: pgsql-sql@postgresql.org

[SQL] design resource

mming but I've not seen a design patterns book for common database problems. Thanks. Edward W. Rouse ComSquared Systems, Inc. 770-734-5301

[SQL] Join question

A|emp1|2 A|emp2|0 A|emp3|0 A|null|2 Thanks, Edward W. Rouse

Re: [SQL] Join question

Sigh, I messed up the tables a bit when I typed the example, org A was supposed to have entries for all 3 users in table a just like org B does, not just the one. Sorry for the confusion. Edward W. Rouse From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edward W. Rouse Sent

Re: [SQL] Join question

I did try that, but I can't get both the values from table a with no entries in table b and the values from table b with null entries to show up. It's either one or the other. Edward W. Rouse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [SQL] Join question

I thought of that, but it does violate table constraints. Edward W. Rouse From: Oliveiros Cristina [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 2:00 PM To: pgsql-sql@postgresql.org; [EMAIL PROTECTED] Subject: Re: [SQL] Join question I don't understand your count(

Re: [SQL] Join question

I have tried left, right outer and inner. Edward W. Rouse From: Daniel Hernandez [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 12:30 PM To: pgsql-sql@postgresql.org; [EMAIL PROTECTED] Subject: Re: [SQL] Join question have you tried a right Join? Daniel Hernndez. San Diego

Re: [SQL] Join question

ng that I could just add the other without changing anything else). And you have pr2.dato in the inner select but not the outer one. Is there a reason for that. As of now I am thinking I will have to break this up into more than one statement. Edward W. Rouse -Original Message- From: [

Re: [SQL] Join question

Finally got it to work. I used 2 separate selects and a union. So one of the selects was like my original left outer joined select and then I unioned it with one that got the missed nulls from the other table. Thanks for all the advice. Edward W. Rouse -Original Message- From: [EMAIL

[SQL] RE: [SQL] Why *no* ambig.uous complain in select part?

Just a guess, but it seems to me that since the join is using col1 and col2 there is no ambiguity. They should be the same no matter which table it comes from. Edward W. Rouse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emi Lu Sent: Friday, August

Re: [SQL] Problem with pg_connect() in PHP

Can I assume the missing ‘.”’ From the end of PG_PASSWORD is a cut and paste error? Edward W. Rouse From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Kitambara Sent: Friday, September 26, 2008 1:22 AM To: pgsql-sql Cc: Kenichiro Arakaki; Ken Arakaki Subject: [SQL

Re: [SQL] Comparing two tables of different database

s are running on the same machine, like the way there is template0 as the default and you add addition databases to the same 'instance'. If you are talking about 2 different database servers, then I have no idea. Edward W. Rouse From: pgsql-sql-ow...@postgresql.org [mailto:pgsq