[EMAIL PROTECTED] writes:
> SELECT * FROM employees
> WHERE status = 'A'
> LIMIT 1
> FOR UPDATE;
> The problem, in the previous sentence, is block every record on
> employees, although we want one record, we want limit 1.
I do not believe that. Could you give a more complete example
...
> When specifying a column data type as timestamp it is always converted to
>timestamptz.
That is true for 7.2.x and earlier, but 7.3 will have the defaults
reversed.
In the meantime, use explicit WITH TIME ZONE and WITHOUT TIME ZONE
clauses on the declaration.
- Thomas
