Skip site navigation (1) Skip section navigation (2)

Re: Converting stored procedure from mySQL

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Cc: Andreas Hjortsberg <andreas(dot)hjortsberg(at)x-change(dot)se>
Subject: Re: Converting stored procedure from mySQL
Date: 2006-06-16 16:36:49
Message-ID: 200606161836.50280.lists@triosolutions.at (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

Am Freitag, 16. Juni 2006 17:39 schrieb Andreas Hjortsberg:
> Basicly I would like to return all the offices and the amount of their
> orders even if they are null. Is it possible to add a temporary table to
> the procedure and instert the data to it,  and then make a select * from
> my_temp_table. Can a function return the result of a temporary table?
Return to what? To the client application? In this case you should consider 
using a view instead of this function. As you say you're migrating from MySQL 
and MySQL didn't support views in older versions, maybe you came up with this 
workaround.

Regards,
Verena

In response to

Responses

pgsql-novice by date

Next:From: CharlieDate: 2006-06-16 19:10:44
Subject: cannot access directory /pg_tblspc/*
Previous:From: Andreas HjortsbergDate: 2006-06-16 15:39:11
Subject: Re: Converting stored procedure from mySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group