[GENERAL] Error when try installing pgbench ?

2005-05-15 Thread Andre Nas
Hello … Im using source  postgresql 8.0.3 under FreeBSD and already install, the database is running well.   I want to install a pgbench, but I can’t install it, coz an error occur. I try to “make all” in directory ~/src/interfaces/lipq/ The messages are : . . . . . . . . . . "../../../src/Makef

[GENERAL] function bit(integer)

2005-05-15 Thread Samer Abukhait
whats the story of the function bit? was it out there some previous versions and got removed lately?? My 8.0.2 PG hasn't this function, if i found this function any where in previous code, shall i replace it with INT::bit(32) ?? ---(end of broadcast)---

[GENERAL] Named Notation for Functions' Parameteres

2005-05-15 Thread Samer Abukhait
Does PostgreSQL support by anyhow the parameter named notation in function calling?? (like oracle's: parameter_name => argument_value) If not, is it on the wish list? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map setti

Re: [GENERAL] Error when try installing pgbench ?

2005-05-15 Thread Michael Fuhr
On Sun, May 15, 2005 at 07:48:53PM +1000, Andre Nas wrote: > > Im using source postgresql 8.0.3 under FreeBSD and already > install, the database is running well. > > I want to install a pgbench, but I can’t install it, coz an error occur. > > I try to “make all” in directory ~/src/interfaces/l

Re: [GENERAL] function bit(integer)

2005-05-15 Thread Michael Fuhr
On Sun, May 15, 2005 at 01:30:05PM +0200, Samer Abukhait wrote: > > whats the story of the function bit? > was it out there some previous versions and got removed lately?? > > My 8.0.2 PG hasn't this function, if i found this function any where > in previous code, shall i replace it with INT::bit(

[GENERAL] Multi-row UPDATE using value from other table?

2005-05-15 Thread Taisuke Yamada
Hi. I'm trying to come up with SQL that updates value of one table (Bby adding SELECTed values from another table. (B (BSay I have two tables: (B (B CREATE TABLE foo (id INT NOT NULL PRIMARY KEY, value INT); (B CREATE TABLE bar (id INT NOT NULL PRIMARY KEY, value INT); (B (BWhat I want to

Re: [GENERAL] Multi-row UPDATE using value from other table?

2005-05-15 Thread Steve Crawford
On Sunday 15 May 2005 6:55 am, Taisuke Yamada wrote: (B> Hi. I'm trying to come up with SQL that updates value of one table (B> by adding SELECTed values from another table. (B> (B> Say I have two tables: (B> (B> CREATE TABLE foo (id INT NOT NULL PRIMARY KEY, value INT); (B> CREATE TABLE

Re: [GENERAL] function bit(integer)

2005-05-15 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Sun, May 15, 2005 at 01:30:05PM +0200, Samer Abukhait wrote: >> whats the story of the function bit? > I don't see the bit() function in the 8.0.3 documentation, so you > might want to stick with documented functionality. bit(n) is a type name, not a

Re: [GENERAL] Error when try installing pgbench ?

2005-05-15 Thread Sven Willenberger
Andre Nas presumably uttered the following on 05/15/05 05:48: Hello … Im using source postgresql 8.0.3 under FreeBSD and already install, the database is running well. I want to install a pgbench, but I can’t install it, coz an error occur. I try to “make all” in directory ~/src/interfaces/l

Re: [GENERAL] function bit(integer)

2005-05-15 Thread Samer Abukhait
I have some code that uses this "type name" and the 8.0.3 is not recognizing it -- Executing query: select "bit"(1); ERROR: function bit(integer) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. ---(end

Re: [GENERAL] function bit(integer)

2005-05-15 Thread Tom Lane
Samer Abukhait <[EMAIL PROTECTED]> writes: > select "bit"(1); > ERROR: function bit(integer) does not exist Try select 1::bit(32); or if you prefer select cast(1 as bit(32)); What you have above is essentially a direct invocation of the int-to-bit cast function; which you can do