Hello,
I am trying to return the most recently updated record from a table:
SELECT max(stopdate) FROM auction;
and this works but only returns the timestamp, however if I try to get
another column with the aggregate it fails:
SELECT title,max(stopdate) FROM auction;
ERROR: Attribute auction.t
I am trying to determine the number of elements in an array.
I looked through the list of loaded functions, and was unable to find one that
seemed to provide this functionality.
Is there some other means to detemine this?
I am new to postgresql and am still trying to learn the 'ordbms way' :-
On Thu, 15 Jun 2000, Karel Zak wrote:
>
> On Thu, 15 Jun 2000, The Hermit Hacker wrote:
>
> > On Thu, 15 Jun 2000, Karel Zak wrote:
> >
> > >
> > >
> > > The PostgreSQL pg_dumplo 0.0.5; in brief:
> > >
> > > --- available at:
> > >
> > > * ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dump
Hi,
I want to find the number of rows for each table (2) in 1 query,
the query is:
select distinct * from medias, contacts WHERE medias.media_id =
contacts.media_id AND medias_categories.media_id = medias.media_id AND
medias_categories.categorie_id = 1
700 rows
If I want to find the
On Thu, 15 Jun 2000, The Hermit Hacker wrote:
> On Thu, 15 Jun 2000, Karel Zak wrote:
>
> >
> >
> > The PostgreSQL pg_dumplo 0.0.5; in brief:
> >
> > --- available at:
> >
> > * ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.5.tar.gz
> >
> > * or will available in the
On Thu, 15 Jun 2000, Karel Zak wrote:
>
>
> The PostgreSQL pg_dumplo 0.0.5; in brief:
>
> --- available at:
>
> * ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.5.tar.gz
>
> * or will available in the PostgreSQL contrib tree in the CVS
What license is it under?
The PostgreSQL pg_dumplo 0.0.5; in brief:
--- available at:
* ftp://ftp2.zf.jcu.cz/users/zakkr/pg/pg_dumplo-0.0.5.tar.gz
* or will available in the PostgreSQL contrib tree in the CVS
--- features:
pg_dumplo [option]
-h --help
Hi,
> I had the same problem but was using Java, not PHP (I guess that
> whatever I can do in JDBC, you can do in PHP ;-)).
>
> SELECT last_value FROM ;
This brings me back to another unanswered question recently posted up, maybe
it is impossible...
I declared a new table with one of the types a
