Re: [SQL] [GENERAL] arrays

2002-10-01 Thread Achilleus Mantzios
I was wondering why is such a rage against arrays. I posted 2 very common problems where arrays provide the only natural (and efficient) fit. (and got no responses) So it seems to me that: - Arrays implementation (along with the intarray package) in postgresql is well performing and stable. -

[SQL] alter user does not changes password

2002-10-01 Thread Lucas Brasilino
Hi all: I know it's a silly question, but I've googling around and searching mailist archive with no answer to my question: I'm using self compiled PostgreSQL 7.2.1 in a RH 7.1 box. As described in http://www.postgresql.org/idocs/index.php?sql-alteruser.html I'm trying to change

Re: [SQL] Stored Procedures

2002-10-01 Thread Roberto Mello
On Tue, Oct 01, 2002 at 06:16:57PM +, [EMAIL PROTECTED] wrote: > Hi all. I'm looking for a little help here. I have a > project where I have to write some stored proceedures > and am having some problems. My main issue is, I cannot > figure out how to return a record set containing > multi

[SQL] please help with converting a view in oracle into postgresql readably code

2002-10-01 Thread mgeddert
Hello, I am trying to convert an application to postgresql, and am having a bear of a time converting the following view (from oracle). What it does, just in case you aren't very familiar with oracle syntax, is group the average reg_state from the events_registrations table after having converted

Re: [SQL] alter user does not changes password

2002-10-01 Thread dima
> alter user camara with password 'canabis!'; > > but when I try to connect: > > $ psql -U camara dbcamara; > > User "camara" logs with no password If I use -W option of psql > It prompts for password and I can enter whatever I want... it accepts! > > It must be a feature.. not a bug.

Re: [SQL] alter user does not changes password

2002-10-01 Thread Tom Lane
Lucas Brasilino <[EMAIL PROTECTED]> writes: > but when I try to connect: > $ psql -U camara dbcamara; > User "camara" logs with no password Did you adjust pg_hba.conf to require password authentication? If so, did you SIGHUP the postmaster after changing the file? reg

Re: [SQL] [GENERAL] arrays

2002-10-01 Thread Roland Roberts
> "Josh" == Josh Berkus <[EMAIL PROTECTED]> writes: Josh> Now, I know at least one person who is using arrays to store Josh> scientific data. However, that data arrives in his lab in Josh> the form of matrices, and is not used for joins or query Josh> criteria beyond a simple

Re: [SQL] [GENERAL] arrays

2002-10-01 Thread Josh Berkus
Achilleus, > I was wondering why is such a rage against arrays. > > I posted 2 very common problems where arrays provide > the only natural (and efficient) fit. (and got no responses) > So it seems to me that: All of your points are correct. Us "old database hands" have a knee-jerk reaction

[SQL] Stored Procedures

2002-10-01 Thread bcschnei
Hi all. I'm looking for a little help here. I have a project where I have to write some stored proceedures and am having some problems. My main issue is, I cannot figure out how to return a record set containing multipule columns. I am looking for a few examples on how I can do this. Most of

Re: [SQL] please help with converting a view in oracle into postgresql readably code

2002-10-01 Thread Roberto Mello
On Tue, Oct 01, 2002 at 10:41:17PM -0700, mgeddert wrote: > create or replace view events_orders_states as select o.*, o_states.order_state from events_orders o, ( SELECT order_id, CASE ( floor (avg (