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
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
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
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
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
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
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
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
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
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:
10 matches
Mail list logo