Dear All,
I am trying to write a function in Postgresql, which takes 2 floats and
returns a box. But seems the nested single-quote in the AS clause
prevent $1 and $2 from being expanded. Besides writing a C function
instead of a SQL one, is there any way to solve this problem?
Thanks a lot.
-S
Tom Lane wrote:
Shilong Stanley Yao <[EMAIL PROTECTED]> writes:
I am trying to write a function in Postgresql, which takes 2 floats and
returns a box. But seems the nested single-quote in the AS clause
prevent $1 and $2 from being expanded. Besides writing a C function
instead of a S
Hi,
I inserted thousands of records in a table, but when using "select
relname, relpages from pg_class;", the number of pages of the table in
which I am inserting records is always 10, which is the same as an empty
table. Am I doing anything wrong? Thanks, -Stan
---(end
Marc Durham wrote:
The relpages value is an estimated value I believe. Try using VACUUM to
update it:
VACUUM mytable;
SELECT relname, relpages from pg_class;
-Marc-
Thank you all for your help. "vacuum" does help! Now I got the
accurate numbers. -Stan
---(end
