I have been creating some user defined C functions using minGW and
postgreSQL 8.3. Everything works great when I use integers,
timestamps, points, etc. I have compiled, linked, created, and tested
multiple function and aggregates.
The problem occurs when I have a text parameter and need to use
PG_
First off, I am developing custom c functions for PostgreSQL 8.3 in
Windows (sorry... not my choice). It appears that there is some
underlying problem in the server that is causing a runtime error to
crash the server when I use palloc. For example... I run the
following:
PG_FUNCTION_INFO_V1(add_on
So what options does that leave all of us who need to compile and run
our custom C functions in Windows?
On Sun, May 4, 2008 at 4:47 PM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> Magnus Hagander wrote:
>
>
> > Dan "Heron" Myers wrote:
> >
>
>
> >
> > > I read somewhere on Postgres' website that th
I am in the middle of switching a bunch of queries over from MySQL to
PostgreSQL and have hit a little snag. The following query works fine
in MySQL but raises an error in postgres:
SELECT COUNT(*), id % 3 AS f1 FROM table GROUP BY f1 HAVING f1 <> 0;
It seems that Postgres does not recognize the
Oops, that second query should be
SELECT COUNT(*), id % 3 AS f1 FROM table GROUP BY f1 HAVING id % 3 <> 0;
On Tue, May 13, 2008 at 3:43 PM, Nathan Thatcher <[EMAIL PROTECTED]> wrote:
> I am in the middle of switching a bunch of queries over from MySQL to
> PostgreSQL and have
Tue, May 13, 2008 at 5:43 PM, Nathan Thatcher <[EMAIL PROTECTED]> wrote:
>
> > Is this the correct way to do this, or is there a better way / a way
> > to get PostgreSQL to recognize an alias in the HAVING clause?
>
> As Tom pointed out, f1's not in scope for the H
I am trying to automatically create a database right after installing
postgres. I launch the silent install (Windows) from my own executable
and once it is done I need to create a database, tables, etc. I am
trying to find a way to do this without having to explicitly enter the
password in at the c
I have, what I imagine to be, a fairly simple question. I have a query
that produces output for a line graph. Each row represents an interval
on the graph.
SELECT COUNT(call_id) AS value, EXTRACT(hour from start_time) AS hour
FROM c_call WHERE start_time >= '2008-08-01 00:00:00' AND end_time <=
'
Brilliant!
On Fri, Aug 1, 2008 at 12:18 PM, Steve Crawford
<[EMAIL PROTECTED]> wrote:
> Nathan Thatcher wrote:
>>
>> I have, what I imagine to be, a fairly simple question. I have a query
>> that produces output for a line graph. Each row represents an interval
>>
