On Mon, 3 Apr 2006 14:57:14 +1000, "Harvey, Allan AC" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Can anyone offer suggestions on how to realise this function
>
> It is the $1 as the table name that is the problem.
>
> I'm using Version 7.4.5
>
> create or replace function last_scan( varchar,
Hi all,
Can anyone offer suggestions on how to realise this function
It is the $1 as the table name that is the problem.
I'm using Version 7.4.5
create or replace function last_scan( varchar, varchar ) returns float as '
declare
result float;
begin
result := value f
Hi, Mr. PG..
what is PG version operating OLAP operations ?
Thanks..
--Hira Sirojudin--
--Jurusan Teknik Komputer dan Informatika - Politeknik Negeri Bandung
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
* Tom Lane ([EMAIL PROTECTED]) wrote:
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> > Am I correct in assuming that when Postgres prepared the SQL to execute
> > the "insert function" that the existing rules on the base table were
> > also resolved at that time? If so, is there any way to av
Michael Trausch <[EMAIL PROTECTED]> writes:
> I'd like to know if I can constrict database and data access
> on a row-level with PgSQL by using some sort of trickery in the database
> configuration itself.
You could do this with views, on the order of
create view secure_view as
se
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> Am I correct in assuming that when Postgres prepared the SQL to execute
> the "insert function" that the existing rules on the base table were
> also resolved at that time? If so, is there any way to avoid that
> behavior?
Yes; no. We are working
[EMAIL PROTECTED] wrote:
hi all,
i am struggling with temp tables. i have a statement like CREATE TEMP
TABLE test (a BIGINT);
it executes successfully, hence i know that the table has been created.
but i cant see the table within the DB using PGADMIN. if i do SELECT *
FROM test; it returns 0 reco
u have to "su postgres" first,just like this:
--
# rehash
# su postgres
postgres$ initdb -D /usr/local1/pgsql/data
good luck!
"Yadu" <[EMAIL PROTECTED]>
news:[EMAIL PROTECTED]
Hi,
I h
hi chris
as u know i'm a chinese and a freshman to postgres so forgive my poor
english.
child table "news_001" dose inherit the table "news".
for that reason it gets all fields which the master has,and i changed
nothing on it.
when i executed a query like
"INSERT INTO news(title,content,author)
Hello everyone,
I'm working with an application, and I'm realizing that perhaps the
model for security that I have used in the past won't work all that well
with the application that I'm working on. I am certain that this
particular model is how web applications traditionally work, but I am
wonde
I have some long-running processes which connect to Postgres, use
PQprepare on a function call, and use PQexecPrepared to effectively
insert rows into a set of partitioned tables (by month).
In a nutshell, up until yesterday I had a base widgets table and a
widgets_200603 table, an INSERT rule in
The propaganda at MediaWiki is sorta vague on Postgresql support.
Has anyone put MediaWiki up using the current version of Postgresql?
Jerry
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
hi all,
i am struggling with temp tables. i have a statement like CREATE TEMP
TABLE test (a BIGINT);
it executes successfully, hence i know that the table has been created.
but i cant see the table within the DB using PGADMIN. if i do SELECT *
FROM test; it returns 0 records, but it still tells me
On April 2, 2006 10:35, Tom Lane wrote:
> Yadu <[EMAIL PROTECTED]> writes:
> > selecting default max_connections ... 10
> > selecting default shared_buffers ... 50
> > creating configuration files ... ok
> > creating template1 database in /usr/local1/postgres/data/base/1 ...
> > FATAL: could not cr
Yadu <[EMAIL PROTECTED]> writes:
> selecting default max_connections ... 10
> selecting default shared_buffers ... 50
> creating configuration files ... ok
> creating template1 database in /usr/local1/postgres/data/base/1 ... FATAL:
> could not create semaphores: No space left on device
> DETAIL:
On Sun, Apr 02, 2006 at 04:03:03AM -0700, Richard Connamacher wrote:
> I've got a question, if anyone can help me out. I know how to use an
> aggregate function to, say, find the lowest price ever listed for a
> product. I also know how to combine that with a SELECT ... GROUP BY
> statement t
Hey all,
I'm new on this list, and have been playing with Postgres a lot this
week. (Love it, by the way.)
I've got a question, if anyone can help me out. I know how to use an
aggregate function to, say, find the lowest price ever listed for a
product. I also know how to combine that with
joseph wrote:
> 2006-04-01 (토), 21:15 -0500, Robert Treat 쓰시길:
>> On Saturday 01 April 2006 17:26, Brendan Duddridge wrote:
...
>> Improved collation support is being worked on but it's a complex problem so
>> there's no realt ETA. (Developers interested in helping out our encouraged
>> to
>> se
2006-04-01 (토), 21:15 -0500, Robert Treat 쓰시길:
> On Saturday 01 April 2006 17:26, Brendan Duddridge wrote:
> > We used to use FrontBase for our databases, but we have since
> > switched to PostgreSQL for
> > performance reasons. However, FrontBase did have very nice collation
> > support.
> >
> > T
Hi,I have installed postgre-sql in directory /usr/local1/postgresNow, I am trying to run /usr/local1/postgres/bin/initdb -D /usr/local1/postgres/dataI got following error.> initdb -D /usr/local1/postgres/data
The files belonging to this database system will be owned by user "postgres".This user m
joseph wrote:
...
> I was on the postgres lists about 1 1/2 years ago, since then i haven't
> been on then. when there was a question about modifying the way
> postgres does collation and supports character sets on a database (as
> opposed to table, or column-level manner) there was much clammer f
21 matches
Mail list logo
