Hello all,
when I try to access the system-table "pg_class", I get the following
error:
zeda=# select * from pg_class;
NOTICE: get_groname: group 1 not found
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or
Hello all,
when I try to access the system-table "pg_class", I get the following
error:
zeda=# select * from pg_class;
NOTICE: get_groname: group 1 not found
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or
shawn everett <[EMAIL PROTECTED]> writes:
> The basic select statement for my problem is going to work as follows:
> select colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2 from table
> where date=SomeDateEnteredByTheUser;
OK, no problem:
create view myview as
select date, colA, colB, c
On Mon, 27 Nov 2000, shawn everett wrote:
> select colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2 from table
> where date=SomeDateEnteredByTheUser;
CREATE VIEW v1 AS
select colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2, date
from table;
SELECT colA, colB, f1, colC, f2
FROM
> What do you consider "passing a parameter to the view" to be?
>
This is where Microsoft Access has twisted me :)
Access as you may or may not know allows you to use parameters in a query:
SELECT * FROM table WHERE table.pkey=[Enter The Primary Key];
The bit in [] represents a prompt to the us
shawn everett <[EMAIL PROTECTED]> writes:
> What I'd like to figure out is the best way to handle the say ~30
> calculations I'll need to do to generate the report. I could query the
> database and then do the calcuations in code via php, I could do them
> using one giant select statement, or I c
Tom Lane wrote:
> Do you have any problem with releasing your stuff under the Postgres
> distribution terms (BSD license)?
No, I don't see any problem with the BSD license, or any other
license, for that matter. I just had some reservations about releasing
stuff that was far from perfect, and it
