Paul Wehr <[EMAIL PROTECTED]> writes:
> create view complex_view as select blah, . , effective_date.date
> from tablea, tableb, tablec, effective_date
> where tablea.foo=tableb.foo
>
> and effective_date.date between tablec.start_date=tablec.end_date
> ;
> insert into effective_date
Summary: Proposed solution, and question on efficiency of technique
I don't know if this is what you are looking for, but I have a database where
I needed a relatively complex view (which I can do thanks to the expanded view
buffer in 7.0!, it didn't fit in 6.5.3), but I need to pass an "effecti
This is not really possible with postgresql at the moment.
Better off trying to work around, perhaps using a view. That way you have a
way to change the select
statement without actually modifying your client code.
Keith.
At 06:09 PM 22/09/2000 -0400, Nelson wrote:
>thank you jie Liang for your
Hi,
So, your question is not client side,
you want store a procedure in db(server side) can accept para from
client side.
I have not seen Pg has a functionality to do like store procedure or
package like Oracle
( maybe I don't know), so , I suggest that :
1 use embeded SQL
2. store query as a SQL
thank you jie Liang for your response, but my problems are:
1. How to store a query in the database.
2. How to give a parameter from outside of database, for example:
select * from table1 where row1 = my_parameter_outside.
Give me an example please.
begin:vcard
n:brito;nelson
x-mozilla-html:F
Hi, there,
If the client machine is a trusted machine in your company, use remote
shell 'rsh' can
call a script of SQL.
If not , you had better use embeded SQL.
I don't know how visual basic embed SQL, but I think is same way as
other language,
in postgres:
#db> create user robot with password '
hi.
I have a problem.
I require to store a query sql in postgresql-7.0 like:
example.
select * from table1 where row1(table1)=parameter1
If i execute this query directly, I don't have problem.
I want to store this query in order to execute from a client program
(visual basic 6.0), but i don't know
