Re: postgresql equivalent to ms access parameter query

--- "David P. Lurie" <dbase4@hotmail.com> wrote:
> What is the postgresql equivalent to an ms access
> 2002 parameter query?
>
> Postgresql functions written in SQL that return sets
> from select queries
> seem closest.

If you like.  But see below.

>
> Table stores has columns of storeid, name, address,
> etc.
>
> A postgresql SQL procedure retrieves records based
> on a single column
> parameter:
>
> CREATE OR REPLACE FUNCTION public.state(varchar)
>   RETURNS SETOF stores AS
> '
>  SELECT * from stores where stateorprovince = $1;
> '
>   LANGUAGE 'sql' VOLATILE;
>
> The following SQL statement runs as expected from
> psql or the pgAdminIII
> query window:
>
> SELECT storeid,storename from state('TN');
>
> How is a parameter passed from access to postgresql
> in a pass-through query
> calling a function?

You've unwittingly provided yourself with the answer
below, i.e. construct a query string using the value
of some control(s).

You just need a piece of code that makes a connection
to the server, constructs a query string, then sends
the query to the server.  ADO is good for this.

So you don't really need a function, because either
way you are doing the same thing, i.e. creating a
query string using passed in values.

>
> A standard access query (non pass-through) to the
> postgresql table can
> reference a text box control on a form:
>
> SELECT public_stores.storeid,
> public_stores.storename,
> public_stores.address, public_stores.city,
> public_stores.stateorprovince,
> public_stores.postalcode
> FROM public_stores
> WHERE
>
(((public_stores.stateorprovince)=[Forms]![Form1]![Text0]));
>
> Thanks,
>
> David P. Lurie
>
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
>       subscribe-nomail command to
> majordomo@postgresql.org so that your
>       message can get through to the mailing list
cleanly


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html