Schema
public
Owner
waveuser002
Descriptions
There is no description for view vwmilinrheeftrrgs
Fields
Name | Data type | Description |
---|---|---|
dnkeymilinrichtingen |
integer |
|
dlrrgs |
char(1) |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Definition
CREATE VIEW public.vwmilinrheeftrrgs (
dnkeymilinrichtingen,
dlrrgs)
AS
SELECT tbmilopslag.dnkeymilinrichtingen,
max(tbmilopslag.dlrrgs)::character(1) AS dlrrgs
FROM tbmilopslag
WHERE tbmilopslag.dlrrgs = 'T'::bpchar
GROUP BY tbmilopslag.dnkeymilinrichtingen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-01-2013 17:28 |
![]() ![]() ![]() |