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: (view raw or whole thread)
Lists: pgsql-novice

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 


In response to


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-2015 The PostgreSQL Global Development Group