think using the 1-byte char is a fairly good choice; you could pack
up your structure in a smaller bit string, but then you add complexity
elsewhere and it might be desirable to keep things simple for now.
Regards,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gian
ed by something like
CREATE TABLE mytable_logged AS
SELECT * FROM mytable_unlogged;
which would not produce WAL:
http://developer.postgresql.org/pgdocs/postgres/populate.html#POPULATE-PITR
unless of course you are using PITR or replication, in which case you
surely want your table to be l
WHERE rank = 1;
-- query not tested as I don't have postgis available
which "feels" more elegant; but you still need a subquery, as window
functions are not allowed in the WHERE clause.
Cheers,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gian