Re: postgresql equivalent to ms access parameter query

--- "David P. Lurie" <dbase4@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)