Peter Lindquist <peter@code42.com> writes:
> bash-2.05a$ cat PG_VERSION
> 7.3
The above is pretty unspecific, please provide "select version()" instead.
> This query returned the correct result of _14_existing_rows_ for the
> payment_id 148004 (each row has a different name):
> select * from t_payment_param where payment_id in (select payment_id
> from t_payment where order_id = 145786);
> Run right afterwords in psql, this query returned only a SINGLE ROW:
> select * from t_payment_param where payment_id in (148004);
This seems mighty broken to me. Can you reproduce it if you create the
index again? Are you quite sure you copied the payment_id value
correctly? For that matter, are you sure the sub-select on order_id
returns only one payment_id?
regards, tom lane
