Skip site navigation (1) Skip section navigation (2)

Re: parameter info?

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: parameter info?
Date: 2013-02-01 04:02:35
Message-ID: CAFj8pRBsTLbOivQ-hWiZrHSvwN84D62afCQ+dLWptAFy+g8wNw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
hello

2013/2/1 Andrew Dunstan <andrew(at)dunslane(dot)net>:
>
> What's the best way for me to find out if a given parameter of a function is
> a constant? The context is that it's expensive to process, and in most cases
> will in fact be a constant, so if it is in fact a constant I'd like to
> process it once and stash the results.
>

you can look into parser tree

see src of get_fn_expr_argtype(fcinfo->flinfo, 0);

Regards

Pavel

> cheers
>
> andrew
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers


In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2013-02-01 04:17:07
Subject: Re: parameter info?
Previous:From: Peter EisentrautDate: 2013-02-01 03:34:49
Subject: Re: recursive view syntax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group