On 12/31/2016 08:25 AM, Thomas Kellerer wrote:
David G. Johnston schrieb am 31.12.2016 um 16:51:
I wonder what the benefit of a typed table is and when this would be
useful?
But I'd say if you want a table with said structure you should plan on
droppign the original type after you've altered
Thomas Kellerer writes:
> I recently stumbled over "typed tables" in Postgres
> (there were several questions containing this on stackoverflow recently)
> create type some_type as (id integer, data text);
> create table some_table of some_type;
> I wonder what the benefit of a typed ta
David G. Johnston schrieb am 31.12.2016 um 16:51:
I wonder what the benefit of a typed table is and when this would be useful?
But I'd say if you want a table with said structure you should plan on
droppign the original type after you've altered all references to it to
point to the new implici
On Saturday, December 31, 2016, Thomas Kellerer wrote:
> I recently stumbled over "typed tables" in Postgres
> (there were several questions containing this on stackoverflow recently)
>
> create type some_type as (id integer, data text);
> create table some_table of some_type;
>
> I wonde
I recently stumbled over "typed tables" in Postgres
(there were several questions containing this on stackoverflow recently)
create type some_type as (id integer, data text);
create table some_table of some_type;
I wonder what the benefit of a typed table is and when this would be useful
Yes I use a migrations tool as well. I like ruby so I use either the Sequel
migrations or the ActiveRecord migrations depending on the project. That's
a great way to work. Having said that I think it might be an interesting
thing to do to create the PGAdmin hierarchy of objects on disk. Not the
dat
Yogi Yang 007 schrieb am 31.12.2016 um 11:06:
Hello,
I am stuck while trying to convert/port a MS SQL server database to pgSQL.
Here is the code of the function in MS SQL server:
CREATE FUNCTION [dbo].[AccountGroupHierarchy]
-- Description:
(
@groupId numeric(18,0)
)
RETURNS @table_variable
Hello,
I am stuck while trying to convert/port a MS SQL server database to pgSQL.
Here is the code of the function in MS SQL server:
CREATE FUNCTION [dbo].[AccountGroupHierarchy]
-- Description: statement>
(
@groupId numeric(18,0)
)
RETURNS @table_variable TABLE (accountGroupId NUMERIC(18,0))
