A query such as "select sum(pages) from job_documents where
delivery_type='print'" returned 0 in version 7.0.3 if there were no rows
matching the query. In 7.1.3 the result is NULL if no rows match the
query. Why the change? Which result is "correct" according to the SQL
standard?
I'm running
"Luis Farfán" wrote:
>
> ello there,
> I'm looking for a (free, shareware) SQL parser and I
> haven't had much
> luck. I was wandering whether it's feasible to get
> postgresql and
> "separate" the parser from the rest of the code and
> use it
> stand-alone. Any experience, suggestions or commen
Peter Eisentraut wrote:
>
> Chau, Artemis writes:
>
> > Does anyone know how to invoke an external shell script from a function when
> > it is called from a sql statement?
>
> If it's a C function, use system("file").
Is this the only way to do this? I would also like to have a trigger
call a
