On 4 Jul 2002, Stephane Schildknecht wrote:
> CREATE RULE boolean_return AS ON SELECT TO DOCUMENT DO INSTEAD
> SELECT
> document_id,
> workflow_id,
> type_document_id,
> image_id,
> theme_id,
> document_version,
> document_surtitre,
Hi,
I'd like to get 1 or 0 from a select on a boolean field.
How could I do ?
I tried the following rule, which I can't insert :
CREATE FUNCTION bool_to_int( boolean ) RETURNS integer AS '
DECLARE
my_bool ALIAS FOR $1 ;
BEGIN
-- Retourn
On Thu, 4 Jul 2002, Rajesh Kumar Mallah. wrote:
Just to add stored procedures in pgsql are implemented
thru functions.
Popular languages are pg/plsql and "C".
>
> Hi ,
>
> Stored procedures are supported in pgsql for
> quite a long time
>
> consult postgresql docs on website
> http://www.pos
Hi ,
you can use GROUP BY , at the expense of adding one more column of SERIAL data type,
say,
select * from t_a limit 10;
access_log=# SELECT * from t_a limit 15;
sno | value
-+---
1 | 4533
2 | 2740
3 | 9970
4 | 6445
5 | 2220
6 | 2301
7 | 6847
8 |
Hi ,
Stored procedures are supported in pgsql for
quite a long time
consult postgresql docs on website
http://www.postgresql.org/idocs/index.php?xplang.html
or your local installations.
regds
malz.
On Thursday 04 July 2002 16:15, srikanth wrote:
> Hi, I am using postgre sql server on linux
On Thu, 4 Jul 2002, srikanth wrote:
You are looking for functions :)
Study them a bit and then you will feel grateful for PostgreSQL!
> Hi, I am using postgre sql server on linux server but for my database I am
> using storedprocedures which i need to create , but there are no commands to
> cre
Mark Frazer wrote:
> Any idea why the table can't be seen with \d in psql then?
It is a known problem with temp tables. They aren't visible with \d
because they are invisible system tables that are removed on exit. I
think 7.3 will fix this.
>
> Christopher Kings-Lynne <[EMAIL PROTECTED]> [02
In my database i have values recorded in one minute intervals. I would
like a query that can get me results for other time intervals. For
example - return maximum value in each 3 minute interval. Any ideas
how i can do this with sql? I tried writing a procedure in plsql but i
am told it does not s
Hi, I am using postgre sql server on linux server but for my database I am
using storedprocedures which i need to create , but there are no commands to
create procedures it says it does not support is there any way to work with
stored procedures in postgre sql server.
thanks,
srikanth.
---
Any idea why the table can't be seen with \d in psql then?
Christopher Kings-Lynne <[EMAIL PROTECTED]> [02/07/04 00:21]:
>
> No - they go away at the end of a _connection_. However, there is now a
> patch floating around on -hackers that would add an ' ON COMMIT DROP;'
> option to CREATE TEMP T
10 matches
Mail list logo
