54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
avataruri text,
rank smallint,
quota integer,
key bytea,
epithet text,
knownsince bigint,
xid text,
invites integer
);
create or replace function
pg_temp.parsavpg_translate_actor(parsav_actors)
returns pg_temp.parsavpg_intern_actor as $$
select
($1).id, ($1).nym, ($1).handle, ($1).origin, ($1).bio,
($1).avataruri, ($1).rank, ($1).quota, ($1).key, ($1).epithet,
($1).knownsince::bigint,
coalesce(($1).handle || '@' ||
(select domain from parsav_servers as s where s.id = ($1).origin),
'@' || ($1).handle) as xid,
($1).invites
$$ language sql;
--drop type if exists pg_temp.parsavpg_intern_post;
create type pg_temp.parsavpg_intern_post as (
-- order is crucially important, and must match the order used
-- in row_to_actor. names don't matter
localpost bool,
|
|
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
avataruri text,
rank smallint,
quota integer,
key bytea,
epithet text,
knownsince bigint,
xid text,
invites integer,
avatarid bigint
);
create or replace function
pg_temp.parsavpg_translate_actor(parsav_actors)
returns pg_temp.parsavpg_intern_actor as $$
select
($1).id, ($1).nym, ($1).handle, ($1).origin, ($1).bio,
($1).avataruri, ($1).rank, ($1).quota, ($1).key, ($1).epithet,
($1).knownsince::bigint,
coalesce(($1).handle || '@' ||
(select domain from parsav_servers as s where s.id = ($1).origin),
'@' || ($1).handle) as xid,
($1).invites, ($1).avatarid
$$ language sql;
--drop type if exists pg_temp.parsavpg_intern_post;
create type pg_temp.parsavpg_intern_post as (
-- order is crucially important, and must match the order used
-- in row_to_actor. names don't matter
localpost bool,
|