diff options
| author | Michael Paquier <michael@paquier.xyz> | 2024-11-14 12:24:00 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2024-11-14 12:24:00 +0900 |
| commit | 3ef038fc4f763f8f6a77c5b3406ab7d837c51c4d (patch) | |
| tree | 2e96a61b09fe347dd9eb65f9f9c152cd9d763d4f | |
| parent | 4e6e375b0039a2afc5830ec5a161536428767e96 (diff) | |
| download | postgresql-3ef038fc4f763f8f6a77c5b3406ab7d837c51c4d.tar.gz postgresql-3ef038fc4f763f8f6a77c5b3406ab7d837c51c4d.zip | |
contrib/lo: Add test for function lo_oid()
Author: Ronan Dunklau
Discussion: https://postgr.es/m/ZzMSJkiNZhimjXWx@paquier.xyz
| -rw-r--r-- | contrib/lo/expected/lo.out | 6 | ||||
| -rw-r--r-- | contrib/lo/sql/lo.sql | 2 |
2 files changed, 8 insertions, 0 deletions
diff --git a/contrib/lo/expected/lo.out b/contrib/lo/expected/lo.out index c63e4b1c704..65798205a5a 100644 --- a/contrib/lo/expected/lo.out +++ b/contrib/lo/expected/lo.out @@ -47,4 +47,10 @@ SELECT lo_get(43214); DELETE FROM image; SELECT lo_get(43214); ERROR: large object 43214 does not exist +SELECT lo_oid(1::lo); + lo_oid +-------- + 1 +(1 row) + DROP TABLE image; diff --git a/contrib/lo/sql/lo.sql b/contrib/lo/sql/lo.sql index 77039509245..ca36cdb3098 100644 --- a/contrib/lo/sql/lo.sql +++ b/contrib/lo/sql/lo.sql @@ -27,4 +27,6 @@ DELETE FROM image; SELECT lo_get(43214); +SELECT lo_oid(1::lo); + DROP TABLE image; |