podoc:number_of_camera_references_sql_function
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
podoc:number_of_camera_references_sql_function [2007/04/13 07:22] – Luud | podoc:number_of_camera_references_sql_function [2007/04/18 14:15] – Luud | ||
---|---|---|---|
Line 6: | Line 6: | ||
=== Description === | === Description === | ||
+ | |||
+ | Counts the number of references for a specific camera. | ||
+ | |||
+ | //Tentative (is this correct? | ||
=== Purpose === | === Purpose === | ||
+ | |||
+ | To retrieve the number of references to a particular camera. | ||
=== Schema === | === Schema === | ||
- | | + | < |
- | as ' | + | create function number_of_camera_references(integer) returns bigint |
- | from photo_tech, camera | + | as ' |
- | | + | from photo_tech, camera |
- | | + | |
+ | | ||
+ | </ | ||
=== Related tables === | === Related tables === | ||
- | === Related indexes === | + | * [[camera sql table|camera]] |
- | + | * [[photo_tech sql table|photo_tech]] | |
- | === Related functions === | + | |
- | + | ||
- | === Related views === | + | |
=== History === | === History === | ||
Line 39: | Line 44: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | < |
- | as ' | + | create function number_of_camera_references(integer) returns bigint |
- | from photo_tech, camera | + | as ' |
- | | + | from photo_tech, camera |
- | | + | |
+ | | ||
+ | </ | ||
podoc/number_of_camera_references_sql_function.txt · Last modified: 2007/04/23 14:30 by Luud