On Wed, Mar 21, 2001 at 10:49:41AM -0500, Bruce Momjian wrote:
Note also that it's a mailing list cultural thing: many lists operate
in a 'post only to the list' mode. Those of us on the pgsql lists do the
'list and person' thing, in response to direct questions, for the reasons
Bruce and
Hans-Jrgen Schnig writes:
Is there any possibility to cast numeric to text in Postgres 7.0.3?
shop=# select cast(price as text) from products;
ERROR: Cannot cast type 'numeric' to 'text'
Use the to_char() function.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Hans-Jrgen Schnig writes:
I am using PostgreSQL 7.0.3. I have tried the isopen() function but it
doesn't seem to work (or it is not fully implemented yet).
In my opinion the third record is a closed path but the isopen()
functions return f.
For no good reason apart from ancient tradition,
Attached is the (I think) corrected version.. If you do like I said and
cut the number in half you see fairly quickly why it didn't work. I'm
sending yours back so you can easily run a diff to see what I did. Let me
know if this (attached "cedars") works.
-Cedar
On Sat, 7 Apr 2001, Josh
Carefully. :)
Try:
where_string := ''WHERE client_name ~* '' || s_client || ;
(I think I got that right.) The way I do it is to write it first as if
I'm not inside a function and not double my single quotes. After I'm
done, go back and double all of them.. you're on you own if
It would be somewhat (very) useful to have something like this. We were
toying with the idea of making some sort of system to figure out if a
table is locked or not. In the end we decided to go with executing this
asynchronously and after a given timeout ask the user if they would like
to wait
