Re: [GENERAL] Interval Rounding

age(now(), change_time)) WHEN (now() - change_time) < '1 hour'::interval THEN date_part('minutes', age(now(), change_time)) END FROM... Any better way to do it? Michael Glaesemann wrote: On Jun 1, 2007, at 12:11 , Mike Ginsburg wrote:

[GENERAL] Interval Rounding

FROM ... to get the interval, and am attempting to use either EXTRACT() or DATE_PART() to get the appropriate value, but the interval doesn't contain any unit higher than days. Any thoughts on how I could accomplish this? Thanks in advance Mike Ginsburg Collaborative Fusion, Inc. [EMAIL

[GENERAL] Large Result and Memory Limit

e was a better way. Thanks in advance for the help. MG Mike Ginsburg Collaborative Fusion, Inc. [EMAIL PROTECTED] 412-422-3463 x4015 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-n

Re: [GENERAL] Large Result and Memory Limit

André Volpato wrote: Mike Ginsburg escreveu: Hello, I am working on a personnel registry that has upwards of 50,000 registrants. Currently I am working on an export module that will create a CSV from multiple tables. I have managed to keep the script (PHP) under the memory limit okay

Re: [GENERAL] Large Result and Memory Limit

Scott Marlowe wrote: On 10/4/07, Mike Ginsburg <[EMAIL PROTECTED]> wrote: export it. Memory limit is a major concern, but the query for one row returns a result set too large and PHP fails. If this is true, and one single db row makes php exceed its memory limit just by return

Re: [GENERAL] A select DISTINCT query? - followup Q

4fifth comment 5sixth comment Thanks, Phil. Mike Ginsburg Collaborative Fusion, Inc. [EMAIL PROTECTED] 412-422-3463 x4015 -- IMPORTANT: This message contains confidential information and is intended only for the individual

[GENERAL] Most Occurring Value

er_id, COUNT(event_id) FROM log GROUP BY (user_id) HAVNG COUNT(event_id) = ??? Any and all help is appreciated. Thank you. Mike Ginsburg [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

[GENERAL] Verify a record has a column in a plpgsql trigger

few of the tables that don't store editor, in which case I am ok with inserting it into the log as NULL. The problem is I can't seem to come up with a conditional to see if NEW has a column named "editor". Any help is greatly appreciated. Thanks. Mike Ginsburg -- Sent

Re: [GENERAL] Verify a record has a column in a plpgsql trigger

Merlin Moncure wrote: On Thu, Feb 4, 2010 at 11:41 AM, Mike Ginsburg wrote: I have a plpgsql function that serves as a change log for a few tables in my db (8.4.2). In most of the tables that I am logging, there is an "editor" column that stores the ID of the user who made the

Re: [GENERAL] Verify a record has a column in a plpgsql trigger

n Thanks again for all the help. I started playing around with custom session vars and it seems to be working well. Mike Ginsburg mginsb...@collaborativefusion.com