On Sat, Feb 18, 2006 at 12:34:23PM -0700, Michael Fuhr wrote:
> On Sat, Feb 18, 2006 at 10:59:16AM -0800, David Rio Deiros wrote:
> > Also, I took me a while to figure out how to compile my trigger on
> > FreeBSD and MacOSX/Darwin. Finally I found this in the documentation
what flags to pass to gcc in order to
compile your code on those and other platforms.
I didn't find any link or reference to that document in the trigger
section. Do you think it would be a good idea to do that?
Thanks,
David
> David Rio Deiros <[EMAIL PROTECTED]> writes:
>
&
On Thu, Feb 16, 2006 at 02:24:06PM -0500, Douglas McNaught wrote:
> David Rio Deiros <[EMAIL PROTECTED]> writes:
>
> > Then, I wanted to run the full php script from the trigger. I tried
> > the script manually, form the shell, and it worked perfectly. Notice
> > th
Hi there,
I have written a trigger in C for a postgresql engine (8.0.1) running
on a FreeBSD 5.4-RELEASE i386 machine.
I mainly used the example code from the documentation. The trigger
is working perfectly and it is triggered when I want to.
Then, at some point, I wanted to call an external php
On Thu, Feb 09, 2006 at 09:51:13PM -0500, Stephen Frost wrote:
> * David Rio Deiros ([EMAIL PROTECTED]) wrote:
> > Now I have to redefine my query because I want to get the second
> > output but keeping the group_id. Ideas and suggestions are welcome.
>
> You might want to
On Thu, Feb 09, 2006 at 07:20:19PM -0500, Tom Lane wrote:
> David Rio Deiros <[EMAIL PROTECTED]> writes:
> > I have some issues with the query attached at the end of this email.
> > If I run that query I got this output ( I have removed some of the
> > fields)
Hi there,
I have some issues with the query attached at the end of this email.
If I run that query I got this output ( I have removed some of the
fields) despite the distinct clause:
QC Q&A | www.xxx.com | 44281
QC Q&A | www.xxx.com | 44281
WhyMAX? | | 44285
But, and here is the w
On Fri, Dec 09, 2005 at 12:29:02PM -0700, Michael Fuhr wrote:
> On Fri, Dec 09, 2005 at 02:17:59PM -0500, Tom Lane wrote:
> > Michael Fuhr <[EMAIL PROTECTED]> writes:
> > > Hmm...I get errors in MySQL 5.0.16 with the query as posted so I
> > > have to wonder what the real query was.
> >
> > (tries
Hi there,
The other day, a coworker who loves mysql was complaining to me because
he had a hard time to find out why this query didn't work on PostgreSQL:
SELECT
AR.artifact_id,
AT.type_nm,
AR.title,
U.dept,
FROM
Artifact_Revisions AR,
Revis
