On 6/5/06, Joe Conway wrote:
Chris Velevitch wrote:
> But what about my original question?
>
> "What is the point of the create or replace view command if you
> can't change the
> column and data types?"
-- create table t1
create table t1(f int);
-- create view v1 based on table t1
creat
On Sun, 04 Jun 2006 15:14:37 -0400 Tom Lane <[EMAIL PROTECTED]> thought long,
then sat down and wrote:
> Frank Finner <[EMAIL PROTECTED]> writes:
> > I run "./configure --with-perl --with-pam --with-openssl"
> > then "gmake"
> > and end up in endless loops of "cd . && ./config.status --recheck"
Chris Velevitch wrote:
But what about my original question?
"What is the point of the create or replace view command if you
can't change the
column and data types?"
-- create table t1
create table t1(f int);
-- create view v1 based on table t1
create view v1 as select * from t1;
-- cre
On 6/5/06, brian ally wrote:
Chris Velevitch wrote:
> Yes, please, what is point of CREATE OR REPLACE FUNCTION, when it
> doesn't let you change the function's parameter list or result type?
The way that user-created functions work allows one to have the same
function name with different numbers
Chris Velevitch wrote:
Yes, please, what is point of CREATE OR REPLACE FUNCTION, when it
doesn't let you change the function's parameter list or result type?
Being able to change the _logic_ of a function is certainly useful.
Well, I find it so, at least - YMMV.
Tim
--
-
Chris Velevitch wrote:
On 6/5/06, Tom Lane wrote:
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> What is the point of the create or replace view command if you can't
> change the column and data types ?
You might as well ask what's the point of CREATE OR REPLACE FUNCTION,
when it doesn't let
On 6/5/06, Tom Lane wrote:
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> What is the point of the create or replace view command if you can't
> change the column and data types ?
You might as well ask what's the point of CREATE OR REPLACE FUNCTION,
when it doesn't let you change the function's
On 6/5/06, Berend Tober wrote:
Chris Velevitch wrote:
> What is the point of the create or replace view command if you can't
> change the column and data types ?
You could have a calculated column and change the calcuation.
You could change the sort order, selection, or grouping clauses.
That
You are getting 190+ secs on the new hardware and 235 secs on the old?
Is the CPU usage maxed out? Assuming linux run top and then press 1.
If in both cases the CPU's are maxed out, then that explains why they are
about the same speed = both are 3GHz Intel CPUs, and your DB fits in RAM.
I've
"Chris Velevitch" <[EMAIL PROTECTED]> writes:
> What is the point of the create or replace view command if you can't
> change the column and data types ?
You might as well ask what's the point of CREATE OR REPLACE FUNCTION,
when it doesn't let you change the function's parameter list or result
typ
Chris Velevitch wrote:
What is the point of the create or replace view command if you can't
change the column and data types ?
You could have a calculated column and change the calcuation.
You could change the sort order, selection, or grouping clauses.
Just to name two.
---
What is the point of the create or replace view command if you can't
change the column and data types ?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
---(end of broadcast)---
TIP 1: if posting/readin
On 6/3/06, Chris Velevitch wrote:
On 6/2/06, Tom Lane wrote:
> "Chris Velevitch" writes:
> > I'm using pg 7.4.5 (cygwin) on win xp sp1.
> > When I enter:-
> > create view v1 as select * from t1;
> > I get:-
> > ERROR: syntax error at or near "view" at character 16
>
> Repeatably?
>
> "vi
On Sun, Jun 04, 2006 at 02:24:32PM -0700, Joseph Brenner wrote:
> I think there are two different "connects" we're talking about here,
> one is the connection to the postgresql, the other is the "connection"
> to the "database" (i.e. the "dbname", which probably should've been
> called the "cata
Terry Lee Tucker <[EMAIL PROTECTED]> wrote:
> Joseph Brenner <[EMAIL PROTECTED]> wrote:
> > > Joseph Brenner wrote:
> >
> > > > After you do a "CREATE DATABASE", how do you programatically
> > > > connect to what you just created?
> > It's not a terribly major point, I'm just wondering if it's
Tom Lane wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> bugasbase2=# SELECT bioassay_id, count(*) from mba_data_base where
>> bioassay_id = 5153 group by bioassay_id;
>> bioassay_id | count
>> -+---
>> 5153 | 2
>> 9712 | 120
>
> That's pretty interesti
Adam Witney <[EMAIL PROTECTED]> writes:
> bugasbase2=# SELECT bioassay_id, count(*) from mba_data_base where
> bioassay_id = 5153 group by bioassay_id;
> bioassay_id | count
> -+---
> 5153 | 2
> 9712 | 120
That's pretty interesting :-(. What PG version is th
Frank Finner <[EMAIL PROTECTED]> writes:
> I run "./configure --with-perl --with-pam --with-openssl"
> then "gmake"
> and end up in endless loops of "cd . && ./config.status --recheck"
> so "configure" runs again and again and again...
Check your system clock ... it's probably set to a time befo
On Sunday 04 June 2006 12:55, P.M wrote:
> Hi,
>
> I would like to know if it exists a good case tool for creating DB into
> PostgreSQL ? thanks a lot,
>
There are several listed at http://www.postgresql.org/docs/techdocs.54
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} Post
Hi,I would like to know if it exists a good case tool for creating DB into PostgreSQL ?thanks a lot,Maileen __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
I have a table to which i bulk load datasets of about up to 20,000
rows at a time. It has a primary key, plus a dataset id (bioassay_id),
however i just ran this query:
bugasbase2=# SELECT bioassay_id, count(*) from mba_data_base where
bioassay_id = 5153 group by bioassay_id;
bioassay_id | coun
Hi!
I found a strange problem during installation on NetBSD with PostgreSQL 8.1.4:
I run "./configure --with-perl --with-pam --with-openssl"
then "gmake"
and end up in endless loops of "cd . && ./config.status --recheck"
so "configure" runs again and again and again...
System:
NetBSD 3.0 on Co
22 matches
Mail list logo
