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
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
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 Berk
On Sun, 8 Apr 2001, Peter Eisentraut wrote:
> Hans-Jürgen Schönig 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.
When w
Hans-Jürgen Schönig 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 traditi
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.
Have I done something wrong, have I got something wrong or is it a bug?
Hans
On Wed, Mar 07, 2001 at 03:40:44PM -0500, Roland Roberts wrote:
> > "bk" == Boulat Khakimov <[EMAIL PROTECTED]> writes:
>
> bk> How do I grant permissions on everything in the selected
> bk> databes?
>
> bk> GRANT doesnt take as on object database name nor does it
> bk> accept
Hans-Jürgen Schönig 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
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
> > Br
On Mon, 2 Apr 2001 [EMAIL PROTECTED] wrote:
> Hi,
>
> I recently posted this same question a few weeks back but lost the reply
> someone kindly sent. The question again how exactly does this query work:
>
> it will return all attributes and respective data types of a given table':
>
> select
10 matches
Mail list logo
