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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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